Excel - count weeks

Asked By Croc on 30-Apr-07 07:18 AM
hello

how can we count how many weeks we have between a specific date in a cell
(A1 for example) and today?
--
Croco




Mike replied on 30-Apr-07 07:30 AM
With today in b1 try this:-

=ABS((B1-A1)/7)

The cell this is in must be formatted as 'Number'

Mike
Mike replied on 30-Apr-07 07:46 AM
Croco,

I did not like the decimal weeks the previous formula gives so try this
instead:-

=INT(ABS((B1-A1)/7))&" Weeks "&MOD(ABS(A1-B1),7)& " Days"
Bob Phillips replied on 30-Apr-07 11:59 AM
=weeknum(TODAY())-weeknum(A1)

you may want to adjust by 1 and compensate for day of the week.

--
HTH

Bob

(there is no email, no snail mail, but somewhere should be gmail in my addy)