convert week numbers into dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

valerie - 18 Apr 2008 22:03 GMT

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

Reply to this Message

Bill Kuunders - 18 Apr 2008 22:36 GMT

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.

Signature

Greetings from New Zealand

> 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.
[quoted text clipped - 5 lines]
>
> V

Reply to this Message