The Excel MONTH function extracts the month from a given date as number between 1 to 12. You can use the MONTH function to extract a month number from a date into a cell, or to feed a month number into another function like the DATE function.
Syntax
The syntax for the MONTH function in Microsoft Excel is:
=MONTH( date_value )
Parameters or Arguments
date_value
A valid date to return the month.
Month Function Examples
Column B of the following spreadsheet shows the Excel Month function, used to extract the month from three different dates.
Formulas:
Results:
