MONTH

Returns Nth months of a date in Excel
Converts a serial number to a month in Excel.

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.

Keep Reading Similar Functions:

Determine the difference between two dates in Excel

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”).

Read More »
Returns the Year component of a given date in Excel

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’.

Read More »
Return only the day value of a date in Excel

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’.

Read More »