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