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

Hi Ric,

You can easily calculate the number of days between today and a future date in Excel by using a simple formula. Here are the steps:

1. First, enter the future date in a cell. Let's say you enter it in cell A1.
2. Next, in another cell, enter the following formula: =A1-TODAY()
3. This formula subtracts today's date (which is given by the TODAY() function) from the future date in cell A1, giving you the number of days between the two dates.
4. The result will be displayed as a number. If you want to format it as a more readable format, such as "X days to go", you can use a custom number format. Right-click on the cell with the formula, select "Format Cells", and then select "Custom". In the "Type" field, enter the following format: "0 ""days to go""" (without the quotes).

That's it! Now you have a cell that displays the number of days between today and the future date, in a readable format.

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" wrote
in message ...

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

Simply subtract the two dates and format as General or Number

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"cardingtr" wrote
in message ...

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

Biff and Sandy Mann,
Thanks!


--
cardingtr
------------------------------------------------------------------------
cardingtr's Profile: http://www.excelforum.com/member.php...o&userid=27027
View this thread: http://www.excelforum.com/showthread...hreadid=564025