Working out weeks from given date.

[mr_spaceuk]

Hi all,

I have a requirement to work out the weeks from a date to current. So im using the following:

=INT((D2-TODAY())/7)

This does come up with a correct number of weeks but its a negative number.
How can I resolve this.

30/09/2002 =INT((D2-TODAY())/7) -395

[martindwilson]

as its always -ve just multiply by -1

=INT((D2-TODAY())/7)*-1

or =ABS(INT((D2-TODAY())/7))

[DonkeyOte]

or if D2 always <= current date simply swap the order in the subtraction.