Counting Weeks

icka · Apr 16th, 2002, 09:11 AM

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 · Apr 16th, 2002, 09:27 AM

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 · Apr 16th, 2002, 09:36 AM

Thanks a lot.
That worked perfectly!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 16th, 2002, 09:11 AM	#1
icka New Member Join Date: Mar 2002 Posts: 5	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

Apr 16th, 2002, 09:27 AM	#2
IML MrExcel MVP Join Date: Feb 2002 Location: Denver, CO Posts: 1,744	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

Apr 16th, 2002, 09:36 AM	#3
icka New Member Join Date: Mar 2002 Posts: 5	Thanks a lot. That worked perfectly!