ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do you create a running countdown that continually runs? (https://www.excelbanter.com/excel-discussion-misc-queries/153917-how-do-you-create-running-countdown-continually-runs.html)

ultra06

How do you create a running countdown that continually runs?
 
I'm trying to create a running countdown that updates and shows the time
counting down to a specific date when I open the excel spreadsheet.

Marvin P. Winterbottom

How do you create a running countdown that continually runs?
 
in cell a1 put the target date, in cell b1 put =today(), in cell a3 put
=a1-b1, a date will show up, but if you format the cell General, it will
change to the number of days between the target date and today.


"ultra06" wrote:

I'm trying to create a running countdown that updates and shows the time
counting down to a specific date when I open the excel spreadsheet.



All times are GMT +1. The time now is 08:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com