count weeks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello

how can we count how many weeks we have between a specific date in a cell
(A1 for example) and today?
 
With today in b1 try this:-

=ABS((B1-A1)/7)

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

Mike
 
Croco,

I didn't like the decimal weeks the previous formula gives so try this
instead:-

=INT(ABS((B1-A1)/7))&" Weeks "&MOD(ABS(A1-B1),7)& " Days"
 
=weeknum(TODAY())-weeknum(A1)

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

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top