count weeks
 

hello

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

count weeks
 

With today in b1 try this:-

=ABS((B1-A1)/7)

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

Mike

"Croco" wrote:

hello

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

count weeks
 

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"

"Croco" wrote:

hello

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

count weeks
 

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

"Croco" wrote in message
...
hello

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