MONTH

Rational

Returns Nth months of a date.

Description

The Excel MONTH function extracts an integer between 1 and 12 that corresponds to the month component of a given date. Example, to get month component of a date (8/15/2017) in cell B5, use =MONTH(B5) that returns ‘8’.

Syntax

=MONTH(serial_number)

Parameters

Serial_number – A valid argument of date, string representation or a serial number of a specific date.

Return Value

An Integer between 1 and 12 (specific month of a year).

Key Notes

• A valid date format in the function may be entered in time, text and serial number format in the specific cell of the worksheet.
• Isolating the month part of a date is appropriate if the application of only month component is required in a specific argument.
• In MONTH function we can’t use a date directly in the formula as a text like =MONTH(03/15/2018) because of the Excel store date in the serial number.
You can also find past and future month from current date like here we have date (11-08-2017) in cell B9 apply formula =MONTH(B9)+3 it return 11.

YEAR

The YEAR function extracts the Year component of a given date. Example; to get or find Year from a date (11/08/2017- cell B5), use =YEAR(B5), returns ‘2017’.

DAY

The DAY function returns an integer value that represents the day element of a date. I.e.; to extract day component, use =DAY(“08-08-2017”) that returns ‘8’.

DATEDIF

The DATEDIF is an unknown compatibility function that can be used to calculate the difference between two dates. To find years diff.,=DATEDIF(start_date, end_date,”y”).