Table of Contents
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.
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)