Convert Week Number to Date

[valerie]

Is there a function or a simple formula that will return a date from a
week number? For instance, a week for my company starts on a Sunday.
Week 15 on my calendar begins with 04/06/08. I would like to enter
15 and have it return the first day of that week which is in my
example 04/06/08.

Thank you so much for your help.

V

 

[Pete_UK]

Suppose you put the date which is the start date of your first week in
cell A1, and the week number of interest in A2 - put this formula in
B2 to find the start date of that week:

=A$1+(A2-1)*7

Format the cell as a date in your preferred style. Copy down if you
want to put other week numbers in A3 onwards.

Hope this helps.

Pete