Syntax
=DATE(year, month, day)| Argument | What it means |
|---|---|
year | The year, for example 2025. |
month | The month 1 to 12. Values over 12 roll into the next year. |
day | The day of the month. Values over the month length roll into the next month. |
Examples with results
Every result below is calculated by the practice engine on the sample data shown, not typed in by hand.
Examples that need no data
=DATE(2025,3,15)A date
=TEXT(DATE(2025,1,31)+30,"dd/mm/yyyy")Add 30 days (shown as day/month/year)
=DATE(2025,14,1)Month 14 rolls into February of the next year
Try it yourself
Change the formula or switch to other sample data.
Press Calculate to see the result.
The practice box runs in your browser with BDK’s own calculator, which covers about 60 common functions. Cell references work as in Excel (B2, B2:B9). Your formulas are not saved or sent anywhere. For anything unusual, check the result in Excel itself.
How people use DATE at work
- HR
Combine a year, month and day typed in separate columns.
=DATE(2024,2,29) - Administration
The last day of a month: day 0 of the next month.
=DATE(2025,3,0)
Common mistakes and tips
- A date is a number underneath. Format the cell as a date to see it properly.
Works in
All versions of Excel, and Google Sheets.
Lessons that use it
Need Something Different? Let’s Talk.
Looking for different features or something built around your workflow? Share your idea with us.