TODAY function in Excel

Syntax

=TODAY()

TODAY takes no arguments: the parentheses stay empty.

Example

=TODAY()-B2 is the number of days since the date in B2.

From the lesson TODAY Function.

Common mistakes

• Typing TODAY without the ().
• Using TODAY() in records that must stay fixed: the value changes every day.

Related date functions

• DATEBuilds a date from year, month and day.
• DATEDIFDifference between two dates in "Y", "M" or "D".
• DAYSNumber of days between two dates.
• EDATEDate a number of months before or after.
• EOMONTHLast day of the month, months away.
• WORKDAYDate a number of working days away.
• YEARReturns the year of a date.
• MONTHReturns the month of a date.