I need to be able to calculate the month from a week number entered onto
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 another
worksheet based on Month returned. (The months on the other worksheet
are in text format)

Can anyone help? I'm stumped!

Thanks Guys


--
ankman
------------------------------------------------------------------------
ankman's Profile: http://www.excelforum.com/member.php...o&userid=16796
View this thread: http://www.excelforum.com/showthread...hreadid=319938