How to set up countdown timer to countdown days to a specific day

J

Jenny

Can you give me a step by step solution as I cannot understand all the script
in the online answers I have found.

Thanks
 
G

Gord Dibben

In A1 enter specific date.........say July 28, 2009

In B1 enter =TODAY()

In C1 enter =A1-B1 and " Days to go" format to General


Gord Dibben MS Excel MVP
 
S

Shane Devenshire

Hi,

We need more info - what do you mean by a countdown time?

=A1-Today()

Enter the specific date in A1 and enter the above formula in A2. Format as
number. It will show the number of days between the two dates.
 
Top