FUNCTION CATALOGUE / DATE & TIME
MONTH Excel function
Extracts the month from a date.
Correct sentence to use
Extract the month number from [date].
Modify this query in PlainFormula →Example formula
=MONTH(A2)
Returns month number.
Syntax
MONTH(serial_number)
Argument signature: serial_number
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.