MONTH

The MONTH function returns the month (1-12) of a date value.

Syntax

=MONTH(serial_number)

Parameters

• serial_number: The date from which to extract the month

Examples

=MONTH("2024-03-15") // Returns 3
=MONTH(DATE(2024, 12, 25)) // Returns 12
=MONTH(TODAY()) // Returns the current month