Explanation
The MONTH function takes just one argument, the date from which to extract the month. In the example shown, the formula is:
=MONTH(B4)
where B4 contains the date January 5, 2016. The MONTH function returns the number 1 representing the month( January) of the date. Note that you can use MONTH to extract the month from a day entered as text:
=MONTH("1/5/2016")
However, using text for dates can produce unpredictable results on computers using different regional date settings. It's better (and more flexible) to supply an address to a cell that already contains a valid date.
Get month name
To extract the month name from a date, you can use the TEXT function, as described in this example.
Related formulas
Get month name from date
Get year from date
Get day from date
Related functions
MONTH Function
The Excel MONTH function extracts the month from a given date as a number between 1 and 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....
DATE Function
The Excel DATE function creates a valid date from individual year, month, and day components. The DATE function is useful for assembling dates that need to change dynamically based on other values in a worksheet.
