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


Returns Nth months of a date.


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




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:

Returns the Year component of a given date in Excel


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


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 »
Determine the difference between two dates in Excel


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 »