How to calculate # of days to the future from TODAY

[cardingtr]

Hello, how to calculate the number of days between today and a future date entered in a certain cell?

I want to put the number of days "to go" before deadline.


Thanks.
Ric

[Biff]

Hi!

Just subtract today from the future date:

A1 = future date = 1/1/2007

=A1-TODAY()

Format the formula cell as GENERAL.

Once the future date has passed the result will be negative.

Biff

"cardingtr" <cardingtr.2bd8s6_1153603808.9122@excelforum-nospam.com> wrote
in message news:cardingtr.2bd8s6_1153603808.9122@excelforum-nospam.com...
>
> Hello, how to calculate the number of days between today and a future
> date entered in a certain cell?
>
> I want to put the number of days "to go" before deadline.
>
>
> Thanks.
> Ric
>
>
> --
> cardingtr
> ------------------------------------------------------------------------
> cardingtr's Profile:
> http://www.excelforum.com/member.php...o&userid=27027
> View this thread: http://www.excelforum.com/showthread...hreadid=564025
>

[Sandy Mann]

Simply subtract the two dates and format as General or Number

--
HTH

Sandy
In Perth, the ancient capital of Scotland

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk


"cardingtr" <cardingtr.2bd8s6_1153603808.9122@excelforum-nospam.com> wrote
in message news:cardingtr.2bd8s6_1153603808.9122@excelforum-nospam.com...
>
> Hello, how to calculate the number of days between today and a future
> date entered in a certain cell?
>
> I want to put the number of days "to go" before deadline.
>
>
> Thanks.
> Ric
>
>
> --
> cardingtr
> ------------------------------------------------------------------------
> cardingtr's Profile:
> http://www.excelforum.com/member.php...o&userid=27027
> View this thread: http://www.excelforum.com/showthread...hreadid=564025
>

[cardingtr]

Biff and Sandy Mann,
Thanks!