Hi Michell Major,

One thing to be aware of if other people are likely to use this workbook on
other systems is that they'll need to have the Analysis Toolpak installed
too, otherwise the WEEKNUM function won't work for them and they'll get no
warnings about it, either.

Cheers

--
macropod
[MVP - Microsoft Word]


"Michell Major" wrote in message
...
Roger

Fantastic!

Dan

"Roger Govier" wrote:

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?