Formula Please

[auzzie]

I need to be able to enter a formula that will calculate the week number between two dates.
08/04/07 = Week 1
15/04/07 = Week 2
22/04/07 = Week 3 etc.

I have the date in cell H1 as =today(), i need H2 to give me the week number from that date. If the date is, say, 17/04/07 i need it to show week 2.
Any help would be appreciated. Thanks in advance. Auzzie

[Wolfeymole]

Try this formula Auzzie;

=IF(H2=H1+7,"Week2",0)

[auzzie]

Hi Wolfey, Tried it but it keeps saying that i have created a circular reference. erm........what's that?!

[Wolfeymole]

Put todays date in H1, put Week 1 in I1
Pull down on H1 formatting the cells in a fill series with a step value of 1 and a stop of 7.
In I2 put the formula as shown

[auzzie]

Thanks Wolfey, got it now.