What formula do I require to achieve the following
Week number
Date sequence
Thanks
Paul
Excel 2013
Printable View
What formula do I require to achieve the following
Week number
Date sequence
Thanks
Paul
Excel 2013
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
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)