count weeks

[Croco]

hello

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

 

[Mike H]

With today in b1 try this:-

=ABS((B1-A1)/7)

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

Mike

 

[Mike H]

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"

 

[Bob Phillips]

=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)