DATE Function
Builds a real date from a year, month and day.
Category
Date & Time
Available in
All versions, Microsoft 365
Returns
A date (serial number)
Overview
DATE turns three numbers — year, month, day — into a date Excel can calculate with. It's the safest way to put a date inside a formula, because it never depends on how a computer's regional settings read 3/4 (March 4 or April 3?).
Behind the scenes every date is a serial number — 1 is 1/1/1900 and 46096 is 3/15/2026 — so dates can be added, subtracted and compared like any other number.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| year | Yes | The year, ideally four digits (2026). |
| month | Yes | The month, 1–12. Numbers outside that range roll into the next or previous year. |
| day | Yes | The day of the month. Too many days roll into the next month; 0 means the last day of the month before. |
Examples
Example 1 — Joining year, month and day columns
Northstar's order system exports the parts of each date in separate columns. DATE puts them back together.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Year | Month | Day | Order date |
| 2 | 2026 | 3 | 15 | 3/15/2026 |
| 3 | 2026 | 12 | 31 | 12/31/2026 |
| 4 | 2027 | 1 | 4 | 1/4/2027 |
Example 2 — Months and days that roll over
DATE quietly fixes out-of-range months and days, which makes month-end maths easy.
| A | B | |
|---|---|---|
| 1 | Formula | Result |
| 2 | =DATE(2026,14,1) | 2/1/2027 |
| 3 | =DATE(2026,3,0) | 2/28/2026 |
| 4 | =DATE(2026,1,32) | 2/1/2026 |
Month 14 is February of the next year, and day 0 of March is the last day of February.
Example 3 — First day of the month
Pull the year and month out of any date and set the day to 1.
Common mistakes
- The answer shows as a number like 46096. The cell is formatted as General. Pick Short Date from the Number Format box on the Home tab.
- Two-digit years. DATE(26,3,15) means the year 1926, not 2026 — years 0–1899 are added to 1900. Always type four digits.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.