convert week numbers into dates

[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

 

[Bill Kuunders]

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.