Converting Week number to calender Date

[Excelboy_01]

Hello People,

Is there an easy way of converting week number and the year into a date? Say, if a user enters:

37 (Weeknumber in cell A1)
2011(Year, in cell A2 )

I would like an out put of 12. Sept. 2011 in Cell A3

Thanks for your help
Moses

 

[Andrew Poulsom]

How about?

=DATE(A2,1,A1*7-2)-WEEKDAY(DATE(A2,1,3))

 

[Excelboy_01]

Thanks a lot Mr. Poulsom

That was swift and very helpful

Moses

 

[dbennett]

I am having this same problem with one more consideration. I have a column which holds an int between 1 & 7 for the days of the week. How can I modify the formula to give me the specified day of the week? I'd like 1 to = Sunday.

Thanks
Diana

 

[Andrew Poulsom]

One way:

=TEXT(A1,"dddd")

where A1 contains the number.

 

[dbennett]

Thanks for the Reply

I was able to use the following to get it to work.

=DATE(A2,1,(B2*7)+C2-1)-WEEKDAY(DATE(A2,1,6))

A2 = Year
B2 = Week #
B3 = Day #