Convert Week Number to Date
 

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

Convert Week Number to Date
 

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


On Apr 18, 10:04*pm, valerie wrote:
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