Nth Day Of Week Number Using Formula

[paul_pearson]

What formula do I require to achieve the following
Week number
Date sequence
Thanks
Paul
Excel 2013

[Gary's Student]

Try these:

If the weeknumber is in A1, then:

=DATE(2013,1,A1*7-2)-WEEKDAY(DATE(2013,1,3)) for Monday
=DATE(2013,1,A1*7-2)-WEEKDAY(DATE(2013,1,3)) + 2 for Wednesday
=DATE(2013,1,A1*7-2)-WEEKDAY(DATE(2013,1,3)) + 4 for Friday

[AAE]

You dates are not valid Excel dates - they are are text.

See if this is what you wanted. It assumes your data is consistently in the format show (3-character day followed by date)

=WEEKDAY(MID(D4,5,LEN(D4)-4)+0)