Convert week number to date

[stepan1987]

Guys,
How can I convert week numver 1,2,3,4,5,6,7,8 and year 2011 into date (ex. sunday of that week)?

Thanks !

 

[energman58]

=D7+((D8-1)*7)+(LOOKUP(D9,{"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday";1,2,3,4,5,6,7}))

Works assuming D7 contains 1/1/2011 (first day of the year as a date - you could replace that with the serial number of that date if you wanted to)
D8 Contains the week number
D9 contains the name of the day you want of that week

This assumes week 1 starts on 1/1 and finishes on the following Saturday and so on - if you have a different definition you need to do something different

 

[stepan1987]

Perfect! Thanks!

 

[jws]

Hello,

I am having trouble converting my week numbers back into specific date.

Ex.

Cell A2 = 35

So what I need is to have week 35 converted into the first Monday date of the week, which would give me 08/22/11

Thanks

 

[energman58]

=40544+((A2-1)*7)-WEEKDAY(40544,3)

Should do it I think

40544 is the serial date for 1/1/2011

Weekday(40544,3) evaluates to 5

 

[jws]

This is perfect, thanks!

Solved