TODAY()

Syntax. TODAY()

Definition. This function returns the serial number for the current date.

Arguments. None

Background. The TODAY() function returns the current date without the time. If you select the General option for the cell format before entering the function, the result is formatted as a date.

The related NOW() function returns both the current date and the time. The difference between TODAY() and NOW() is that TODAY() returns only the current date and NOW() returns the date and the time.

To calculate date differences from the current date, use the TODAY() function. You can use the TODAY() function to calculate the number of days since an invoice was issued. With the help of the calculated difference, you can see if deadlines were met ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.