Hi Michell Major,

=INT((A4-DATE(YEAR(A4),1,1))/7+1)
returns '49' for "3/12/2006"=A4<="9/12/2006" - a span of 7 days/1 week.

I don't understand the bit about the month, though.

Cheers
PS: 31/12/2006 will be the 1st day in week 53.

--
macropod
[MVP - Microsoft Word]


"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?