[mrtbag]

Hi All,

I do quite a few reports in Excel and they are usually 'monthly'. My boss now wants a particluar report that looks at things by week number. So iave a standard date field (dd/mm/yyyy hh:mm:ss) and I want to write an IF statement for another column that is along the lines of:

IF Date_1 is between 01/01/07 and 07/01/07 Then = Week 1

But I want to write 1 large statement with all the week No's I can just copy into my reports each time the boss wants week numbers.

If somebody can tell me how to format the 1st bit, I can then just repeat it for the rest. Or does anybody know an easier way?

[mrtbag]

No Worries guys. I have found the WEEKNUM function!! For some reason this is not a default setting and you have to install the Analysis Toolpack.

Mods, please close.