calculate month from week number

A

ankman

I need to be able to calculate the month from a week number entered ont
a worksheet. i.e.

week Month
1 Jan
2 Jan
3 Jan
4 Jan
5 Feb

A sumif statement will then be used to extract data from anothe
worksheet based on Month returned. (The months on the other workshee
are in text format)

Can anyone help? I'm stumped!

Thanks Guy
 
B

bveara

This works too. Cell A14 has the week number. Cell B14 has the year.
Returns the date of the Monday of that week.

=DATE(B14,1,1)+((A14-1)*7)-WEEKDAY(DATE(B14,1,1)+(A14-1)*7,2)+1

-BV
 
Top