convert week numbers into dates

  • Thread starter Thread starter valerie
  • Start date Start date
V

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
 
One way

enter in B1
=39439+A1*7
format B1 cell as a date
enter the week number in A1

Every year the number 39439 will have to be changed to reflect the date of
the last week in the previous year.
 
Back
Top