# DATE, YEAR, MONTH & TEXT (Excel lesson 23 of 45)

> A date is a number wearing a costume.

Source: https://spreadsheetpractice.com/learn/date-year-month-text · Updated October 29, 2026

- **Course:** [Excel course](https://spreadsheetpractice.com/learn), track "Dates"
- **Time:** about 8 minutes, 3 graded exercises
- **Functions:** `DATE`, `YEAR`, `MONTH`, `TEXT`
- **Access:** Pro (the lesson text is free; the graded exercises need Pro)
- **Key formula:** `=YEAR(A2)`: 2026

## How it works

Excel stores a date as the count of days since January 1, 1900, so 1/15/2026 is 46037. That's why you can subtract two dates to get days between them.

`YEAR`, `MONTH` and `DAY` pull the parts out. `DATE(year, month, day)` builds a date from parts. `TEXT(date, "mmm")` turns a date into a label such as Jan.

## Syntax

| Formula | What it does |
|---|---|
| `=YEAR(A2)` | 2026 |
| `=MONTH(A2)` | 1 |
| `=TEXT(A2,"mmm")` | Jan |
| `=TEXT(A2,"dddd")` | Thursday |
| `=DATE(F2,G2,H2)` | Build a date from parts |

## Watch out for

- TEXT returns text, so sort and filter on the real date, not the label.
- DATE rolls over: DATE(2026,13,1) is January 1, 2027.

## The exercises

Solve them in the live grid at [DATE, YEAR, MONTH & TEXT](https://spreadsheetpractice.com/learn/date-year-month-text). Each answer is graded, then re-checked on changed data so typed-in numbers don't pass.

1. **Year and month.** Fill B2:B6 with the year and C2:C6 with the month number of each invoice date.
2. **Month labels.** In D2, show the three-letter month name (Jan, Feb…) for each invoice date. Fill down to D6.
3. **Build due dates.** In I2, build a real date from the year, month and day in F2:H2. Fill down to I6.

Previous: [Splitting and counting list cells](https://spreadsheetpractice.com/learn/textsplit-count-clean-lists) · Next: [EDATE, EOMONTH & NETWORKDAYS](https://spreadsheetpractice.com/learn/edate-eomonth-networkdays)

---

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