DATES

Date Functions

Extract and work with year, month and day values.

After this lessonCreate time-based reporting helpers.

How it works

Excel stores dates as serial values and displays them with formatting. YEAR, MONTH and DAY extract date components that are useful for grouping and reporting.

When imported dates behave like text, convert them before relying on date calculations. Always validate date format assumptions for international data.

REAL WORK

Create month buckets, calculate reporting years or split a timestamp into reporting dimensions.

SYNTAX

The pattern

=YEAR(A2)
=MONTH(A2)
=DAY(A2)

Example

=YEAR("2026-09-14")

TRY IT

Test the formula

The sample sheet is local to this page. Change the formula and see the result immediately.

Result

QUICK CHECK

Which function returns the month number?

Progress is stored only in this browser. No account required.