Returns the month of a date represented by a serial number.
Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.
MONTH(serial_number)The MONTH function extracts the month from a given date, returning an integer from 1 (January) to 12 (December). It requires a valid Excel date format or a serial number representing a date.
=MONTH("2023-05-15")Ergebnis: 5
Extracts the month from May 15, 2023.
It will return a #VALUE! error.