Menu
EXCEL TODAY FUNCTION
Excel TODAY Function Introduction
The current date is returned by this method. (In Excel, a serial number represents a certain date.)
Description of Excel TODAY Function
Syntax:
=TODAY ()
There are no parameters for this function, but it does require empty parenthesis. This function can be used to determine a person’s age in years like this. =YEAR( TODAY())-1980 =YEAR( TODAY())-1980 =YEAR( TODAY())-19 To find the current year, this formula takes the TODAY function as an argument in the YEAR function, then subtracts 1980 to get the difference in years.
- The date is returned by the = TODAY () function.
- The current date plus 7 days is returned by = TODAY () +7.
Step By Step Guide of TODAY Function
Key Points
TODAY is a volatile function that can cause spreadsheet performance issues.
TODAY shows the current date but not the time. Use NOW to make a date with the current time.
Rather than remaining at the date when the spreadsheet was first input,
TODAY will always represent the current date when the spreadsheet was last recalculated.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
