Google Sheets - MONTH function
MONTH function returns the month part of a date. For example, the month part of 2/15/2020 is 2. Syntax MONTH(date) Examples Notes You can use any format for the dates, as long as they are valid dates. The MONTH function will return an error if the argument is not a valid date, such as "15/2/2019"