# DATE function in Excel

> DATE builds a real date from a year, month and day.

Source: https://spreadsheetpractice.com/functions/date · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** DATE builds a real date from a year, month and day.
- **Syntax:** `=DATE(year, month, day)`
- **Most common use:** `=DATE(A2,B2,C2)` returns 7/15/2026 (Builds July 15, 2026 from three numbers)
- **Available in:** Every current version
- **Category:** [Date functions](https://spreadsheetpractice.com/functions/category/date)
- **Returns:** A date serial number. Format the cell as a date to see it as one.
- **Google Sheets:** Works the same in Google Sheets.

## What it does

DATE builds a real date from a year, month and day. Use it when the parts sit in separate columns, or to calculate dates like the first of a month. Because it rolls overflow forward, month 13 becomes January of the next year and day 0 becomes the last day of the previous month.

## Syntax

`=DATE(year, month, day)`

| Argument | Required? | What it is |
|---|---|---|
| `year` | Required | The year as a four-digit number, such as 2026. |
| `month` | Required | The month number. Values above 12 or below 1 roll into the next or previous year. |
| `day` | Required | The day of the month. Values past the month's end roll into the next month; 0 gives the last day of the previous month. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| F2 | `=DATE(A2,B2,C2)` | 7/15/2026 | Builds July 15, 2026 from three numbers |
| F3 | `=DATE(A3,B3,C3)` | 2/1/2027 | Month 14 rolls over into February of the next year |
| F4 | `=DATE(YEAR(E2),MONTH(E2),1)` | 9/1/2026 | First day of the month for the order date in E2 |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Year | Month | Day |  | Order date | Result |
| 2 | 2026 | 7 | 15 |  | 9/18/2026 | 7/15/2026 |
| 3 | 2026 | 14 | 1 |  |  | 2/1/2027 |
| 4 | 2026 | 3 | 0 |  |  | 9/1/2026 |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| A number like 46218 instead of a date | The formula is right; the cell is formatted as General. Apply a date format. |
| Wrong date when the year is two digits | DATE(26,7,15) means the year 1926, because Excel adds 1900 to years from 0 to 1899. Always pass four-digit years. |
| #VALUE! | One of the parts is text that isn't a number, such as "July". Pass the month as a number from 1 to 12. |

## Tips

- DATE(year, month + 1, 0) returns the last day of a month, a handy alternative to EOMONTH.
- Build dates from text parts with DATE(LEFT(A2,4), MID(A2,5,2), RIGHT(A2,2)) when an export gives you 20260715.

## Related functions

- [YEAR](https://spreadsheetpractice.com/functions/year): YEAR returns the four-digit year from a date.
- [MONTH](https://spreadsheetpractice.com/functions/month): MONTH returns the month of a date as a number from 1 to 12.
- [DAY](https://spreadsheetpractice.com/functions/day): DAY returns the day of the month from a date, as a number from 1 to 31.
- [EOMONTH](https://spreadsheetpractice.com/functions/eomonth): EOMONTH returns the last day of the month a number of months before or after a date.
- [DATEVALUE](https://spreadsheetpractice.com/functions/datevalue): DATEVALUE converts a date that is stored as text into a real date that Excel can sort, subtract and format.

## Questions

### How do I combine year, month and day columns into one date?

Use =DATE(A2,B2,C2) with the year, month and day cells in that order, then format the result as a date.

### Why does DATE return a number?

Excel stores dates as numbers counting days from January 1, 1900. The value is correct; change the cell format to Date to display it.

### Can DATE handle a month greater than 12?

Yes. Extra months roll into the next year, so DATE(2026,14,1) returns February 1, 2027. This makes date arithmetic like adding months reliable.

## Practice

A graded DATE exercise ("Build due dates") is on [the DATE page](https://spreadsheetpractice.com/functions/date). It is checked instantly, then re-checked on changed data.

Lessons that use DATE:

- [Lesson 23: DATE, YEAR, MONTH & TEXT](https://spreadsheetpractice.com/learn/date-year-month-text) (Pro)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
