DAYS()

Want to know how many days until Christmas or any particular holiday? Here is a nice little function.

DAYS(date_2;date_1) - This function calculates the number of days between two dates.

In my example, I am also using the TODAY() function. It has no argument. It returns today's date. You just need to make sure your computer is set to the correct date.

Cell B1 contains the formula =DAYS("12/25/08";TODAY())

Notice: You have to put quotes around the date.

Here is a screen shot.