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.