The MONTH function is a simple date function that extracts just the month from a given time. If you are working with times, but only care about the months, the MONTH function lets you get rid of everything else. Remember that dates are really just saved as numbers by your spreadsheet with date formatting applied.
The MONTH function returns the value of the month from any given unit of time.
Example 1 – Plain and Simple
A few simple examples of the MONTH function.
||Extract the month value from 10/5/2016.||10|
||Return of the of the month of October.||#VALUE!|
||Extract the month value from October 8||10|
Tip: Notice that the MONTH function can’t figure out that what you mean by “October” unless you put a day value in front of it. See how dates and times work to make a little sense out of this.
Live examples in Sheets
Go to this spreadsheet for the examples of the YEAR, MONTH, DAY, HOUR, MINUTE, and SECOND functions shown above that you can study and use anywhere you would like.