Excel Countdown formula - AdvantEdge Training & Consulting

Excel Countdown formula

How many days until the end of the year? How many days until the big meeting? Use this simple Excel countdown formula to find out.
The DATEVALUE formula converts a date into a number in Microsoft Excel date-time code. This allows you to do simple math with days and time and create an Excel countdown formula.
=DATEVALUE(“31-March-2012″)-TODAY()&” days until final numbers are due”
The red section of the code does the math needed, and the blue section of the code adds “Days until Final numbers are due” to the cell. I included this to force Excel to use a number instead of printing the results in Date Time Format.
If you don’t want a simple number instead, remove the blue section of the code. Then change the number format under the Home tab to “Number”.
Excel Countdown formula - view_as_number
There are a few other applications for this beyond a simple Excel countdown formula too.
 
 

 

For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top