DATE, DAY, MONTH & YEAR

DATE

Creates a valid Excel date from year, month, and day values.

Syntax:

=DATE(year,month,day)

Example:

=DATE(2026,9,28)

Result: 28-Sep-2026

DAY

Returns the day of the month.

=DAY(A2)

If A2 = 28-Sep-2026:

Result: 28

MONTH

Returns the month number.

=MONTH(A2)

Result: 9

YEAR

Returns the year.

=YEAR(A2)

Result: 2026

Practice