TODAY Function

Today Function

About

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

Function Type

Date and time

Purpose

Return current date

Return value

An Excel date

Syntax

 =TODAY()

Arguments

TODAY function doesn’t have a argument.


Examples

Current Date

The following formula will return the current date.

=TODAY()

Yesterday’s and Tomorrow’s date

Add 1 to TODAY function for Tomorrow’s date

=TODAY()+1

Subtract 1 from TODAY function for Yesterday’s date

=TODAY()-1

Notes

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.


Shortcut

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