Hi

Why not just the weeknum function?
=WEEKNUM(A1)

For this to work you need Analysis Toolpak. ToolsAddinsClick Analysis
Toolpak.

--
Regards

Roger Govier


"Michell Major" wrote in
message ...
=IF(AND(A4="4/12/2006",A4<="9/12/2006"),"49")

This should show next week as 'Week 49' but doesn't. I want to add
another
three IF to this string so that I can get the month sorted out in Week
order?