Related Function:

The TODAY function returns a serial number representing the current date in Excel.

Syntax

=TODAY()

Note: TODAY uses no parameters, but requires that you use empty parentheses ().

  • The value returned by TODAY will continually update each time the worksheet is recalculated, e.g. each time a cell value is entered or changed. Use F9 to force the worksheet to recalculate and update the value.
  • If you need a static date that won’t change, you can enter the current date using the keyboard shortcut Ctrl + Shift + ;

Examples

  A B C
1 Formula Result Notes
2 TODAY()  7/27/2015 Returns the current date
3 TODAY()-7 7/20/2015 Returns the current date minus 7 days. For example, if the current date is 7/27/2015, this formula returns 7/20/2015
4 TODAY()+7 8/3/2015 Returns the current date plus 7 days. For example, if the current date is 7/27/2015, this formula returns 8/3/2015
5 =DAY(TODAY()) 27 Returns the current day of the month (1 – 31)
6 =MONTH(TODAY()) 7 Returns the current month of the year (1 – 12). For example, if the current month is July, this formula returns 7

Common Function Error(s)

Problem What went wrong
When subtracting a date from the result the TODAY function, the result looks like a date, e.g. “16/11/1900”), instead of an integer Likely due to cell formatting, i.e. the function has returned the correct value, but the cell is formatted as a ‘date’, instead of an integer