Dates require through week number

Hello Everyone,

I want to return date through week number for example:- if I have week numbers 0-10 in range A1:A10, and I want to return the start date and last date so how can I return.


Thanks in Advance

Assuming you have Week number given in A1 and by default you are looking for 2015 only. If you also wants to switch in years. then change the 2015 to your cell which contains year.

"=MAX(DATE(2015,1,1),DATE(2015,1,1)-WEEKDAY(DATE(2015,1,1),2)+(A1-1)*7+1)"

Cheers!!!
Anil Dhawan

Here!

Put this in B1 for Start Date - =MAX(DATE($E$1,1,1),DATE($E$1,1,1)-WEEKDAY(DATE($E$1,1,1),2)+(A1-1)*7) (Assuming Cell E1 will have Year)

Put this in C1 for End Date - =B1+(7-WEEKDAY(B1,1))

Thanks Anil Dhawan and NeedforExcel it works.

Hey Nisha,

Thanks for adding rep.

If your query has been resolved, please mark this thread as SOLVED.