How do you create a running countdown that continually runs?

U

ultra06

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.
 
M

Marvin P. Winterbottom

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.
 
Top