Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
DATE
DATE assembles a valid date from three numeric inputs — year, month, and day — returning the corresponding Excel/Sheets serial number. It handles out-of-range month and day values automatically (e.g., month 13 becomes January of the next year), making it ideal for date arithmetic, building dates from text parts, or constructing dynamic date ranges.
Excel
=DATE(2025,5,27)Google Sheets
=DATE(2025,5,27)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Year | Month | Day | Date |
| 2025 | 1 | 15 | 2025-01-15 |
| 2025 | 6 | 1 | 2025-06-01 |
| 2024 | 12 | 31 | 2024-12-31 |
=DATE(2025,5,27)→45804
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Supply year, month, and day as separate numbers or cell references: =DATE(A2,B2,C2).
- 2Excel automatically adjusts for overflow: =DATE(2025,13,1) resolves to January 1, 2026.
- 3Format the result cell as a Date; subtract one DATE from another to calculate the interval in days.
Need a version for your data?
Try: “Combine separate year, month, and day columns into a single date value”