DATE Function in Excel: Syntax, Examples and Free Practice
DATE is an Excel Date & Time function. Builds a real date value from separate year, month, and day numbers.
DATE syntax
Arguments
year: The year component of the datemonth: The month component of the dateday: The day component of the date
When to use DATE
DATE is used in scheduling, deadline tracking, and reporting that spans specific date ranges.
Practice DATE online, free
Open the live Excel-style spreadsheet and try DATE yourself. No Excel install or sign-up needed to start.
Practice DATE now →Watch: DATE in Excel
More Date & Time functions
Frequently asked questions
What does the DATE function do in Excel?
Builds a real date value from separate year, month, and day numbers.
What is the syntax of DATE in Excel?
The syntax is =DATE(year, month, day). year: The year component of the date; month: The month component of the date; day: The day component of the date.
Where can I practice DATE online for free?
Open the free live spreadsheet on Cellgrids and try DATE yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Date and Time functions · Excel case studies · Excel tutorials · Excel shortcuts