MONTH

Definition: MONTH is a function that returns the month component of a given date.

Syntax: =MONTH(serial_number)

Situation: This formula is appropriate when you need to find the month component of a given date.

Example: If you have a date value 1/15/2022, the month component can be found using the formula =MONTH(“1/15/2022”), which returns 1.