Skip to Content

MONTH

Returns the month of a date represented by a serial number. The month is given as an integer, ranging from 1 to 12

Syntax

MONTH(serial_number)

Parameters

  • serial_number: Required. The date of the month you are trying to find

Example

=MONTH("15-Apr-2024")
Returns: NumberSince: Excel 2003