count down the days???

[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

[Dave Peterson]

=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

[pinmaster]

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

HTH
JG