Explanation

DAY, MONTH, YEAR are used for extraction of the day, month and year part from an Excel date.

Let’s see how it works!

Syntax

To extract the day from the date:

=DAY(serial_number)

In the serial_number we can type the date, with quote marks – DAY(“13/05/2019”) or reference a cell which contains a date – DAY(A1)

To extract the month from the date:

=MONTH(serial_number)

In the serial_number we can type the date, with quote marks – MONTH(“13/05/2019”) or reference a cell which contains a date – MONTH(A1)

To extract the year from the date:

=YEAR(serial_number)

In the serial_number we can type the date, with quote marks – YEAR(“13/05/2019”) or reference a cell which contains a date – YEAR(A1)

Practice DAY, MONTH & YEAR functions

Let’s practice these functions: