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:-
The cell this is in must be formatted as 'Number'
I did not like the decimal weeks the previous formula gives so try this
=INT(ABS((B1-A1)/7))&" Weeks "&MOD(ABS(A1-B1),7)& " Days"
you may want to adjust by 1 and compensate for day of the week.
(there is no email, no snail mail, but somewhere should be gmail in my addy)