Finding the date using the number of the week in a year

[Guest]

Hi All,

I have manipulated some data and managed to get the week number of each row
and the day of that week (a number from 1 to 7, 1 = monday, 7 = sunday) in
any particular year.

e.g. for today (27 Mar 2007):
week number = 13
year = 2007
day = 2 (2 for tuesday).

Using this data, is there anyway i can return the actual date for today
(e.g. 27-Mar-07) using a formula ?

Any help would be much appreciated.

Regards,

Bhupinder.

 

[JE McGimpsey]

One way:

A1: 2007
A2: 13
A3: 2

B1: =DATE(A1,1,A2*7-WEEKDAY(DATE(A1,1,0))+A3-6)

 

[Guest]

great, nice one JE, cheers.

One way:

A1: 2007
A2: 13
A3: 2

B1: =DATE(A1,1,A2*7-WEEKDAY(DATE(A1,1,0))+A3-6)