count down the days???

  • Thread starter Thread starter Ltat42a
  • Start date Start date
L

Ltat42a

how can I calculate the number of days from a date in the future from
today?

B3 = 08/10/2006

Sorta like "??? # of days until Christmas"

Thanx
 
=date(2006,12,25)-date(2006,08,10)
format as general.

If the date is in A1:
=date(year(a1),12,25)-a1
(still format as general)
 
Back
Top