DATE function in Excel

Syntax

=DATE(year, month, day)

Example

=DATE(2024,3,15) is 15 March 2024. =D2+30 is 30 days later.

From the lesson DATE Function.

Common mistakes

• Typing dates as text, so they cannot be calculated with.
• Forgetting to format the cell as a Date, so you see a serial number.

Related date functions

• TODAYReturns today's date.
• 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.