Functions
MONTH
Month number from a date serial number
Try it
When to use it
What does MONTH return?
MONTH takes a date and returns its month as a number from 1 to 12, where 1 is January and 12 is December.
How do I group transactions by month?
Apply MONTH to each date to get a 1-to-12 number, then use it as the key in a SUMIF or COUNTIF to total figures per month.
Use cases
Find the month a sale closed
Extract the billing month
Used in
Syntax
MONTH(date)Examples
=MONTH(DATE(1969,7,20)) // => 7
=MONTH(40909) // => 1
=MONTH("7/20/1969") // => 7