Counting Weeks

[icka]

I want to count how many weeks are between a date and today's date.

Cell G2 is 1/18/2001. In H3 is the forumla and the result of the amount of weeks.


Thanks

[IML]

you could use
=(TODAY()-G2)/7

and format as general.

Or dress it up a little with something like:
=INT((TODAY()-G2)/7)&" week(s)"&IF(MOD(TODAY()-G2,7),", "&MOD(TODAY()-G2,7)&" day(s)"," exactly")


good luck

[icka]

Thanks a lot.
That worked perfectly!