count down the days???
 

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


--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=479309

count down the days???
 

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


Ltat42a wrote:

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

--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=479309

--

Dave Peterson

count down the days???
 

Hi
=DATEDIF(TODAY(),A1,"d")

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=479309