| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I use excel to countdown to a future date?
paulf wrote:
I want to count time down to a future date using excel. I want the display to continually count, not just display the time at last save. Any ideas? TODAY() will always return the current date, not just when last saved. So, if the future date is in a cell, like A1, then =A1-TODAY() should give the countdown in days. You will probably need to change the format of the result to General or some such to make it more meaningful. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countdown to date and time | Excel Discussion (Misc queries) | |||
| Countdown by Date | Excel Worksheet Functions | |||
| How do I calculate a future date in excel? | Excel Worksheet Functions | |||
| How do I calculate a future date in Excel? | Excel Worksheet Functions | |||
| How do I Calculate a future or past date in Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
