Excel countdown timer until a date

Do you need to add a timer into one of your excel files to countdown the number of days until a certain date or deadline ?
Just place this formula in the cell you want the value to be displayed. This example will show the number of days between today and the end of 2014.

=DATEVALUE("31-12-2014")-TODAY()&" days remaining in 2014"

Formula explained:
DATEVALUE(text) is a excel function that converts a date to a number that can be used in calculations.
TODAY() is a function that returns the current date as a number using the computer's system clock.

This part of the formula =DATEVALUE("31-12-2014")-TODAY() subtracts the number for today from the number for your future date, resulting in the number of days between the two dates.
&" days remaining in 2014" displays text in front of the number retunred by the formula.