Thanks that is alot simpler to understand than what i was trying.
However this formula doesn't work if the week number is less than 26.
But i think the answer is close.

Cheers

James


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=503604