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
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
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
Thanks a lot.
That worked perfectly!
Like this thread? Share it with others