Week # Date function

Good day,

If I have the following data:

a) WeekNum
b) Year

Can I calculate the Beginning Date of any Week?

For example, can I find out the start date for Week #5 with these two sets of data?

Thanks,
E

Hello Erick,

Yes you can but it depends how you're defining your week numbers, there are several ways. If you are using the same definition as Excel's weeknum function where week 1 always starts on 1st Jan and week 2 on the next Sunday then with year in A1 and weeknum in B1 try

=DATE(A1,1,9)-MIN(8,WEEKDAY(DATE(A1,1,8))-(B1-2)*7)

If your week numbers are defined differently then how is that, when does week 1 start and is that on a Sunday or Monday?

LOL, Daddylonglegs - you're a monster.

How in the world?.. Did you just flip open your formula book? Well, never mind - it worked perfectly.

Thanks again,
EG