TODAY Function

Today Function


The Excel TODAY function is a DATE & TIME function that can return the current date.

Function Type

Date and time


Return current date

Return value

An Excel date




TODAY function doesn’t have a argument.


Current Date

The following formula will return the current date.


Yesterday’s and Tomorrow’s date

Add 1 to TODAY function for Tomorrow’s date


Subtract 1 from TODAY function for Yesterday’s date



TODAY function is a Volatile function that will update every time when a worksheet or workbook is recalculated.

To return current time use NOW function.


CTRL + ; is the shortcut to return the current date into a cell. Note that the date generated using this shortcut is a static value and won’t update.

Read about Excel Functions

Excel Functions in Alphabetical Order (Complete list)

Complete List of Excel Functions (Category wise)

New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel