![]() |
How do I use excel to countdown to a future date?
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? |
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. |
All times are GMT +1. The time now is 12:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com