top of page

DAY, MONTH, YEAR FUNCTIONS

The DAY, MONTH, and YEAR functions are utilized to extract the day, month, and year components from a date in Excel. Let's explore their functionality!

=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)

=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)

=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)

bottom of page