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