Google Sheets-funktion

MONTH

Returns the month of a date represented by a serial number.

Skapa en formel med AI Samma funktion i Excel

Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.

Syntax

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.

Argument

serial_numberobligatorisktThe date of the month you are trying to find.

Exempel

=MONTH("2023-05-15")

Resultat: 5

Extracts the month from May 15, 2023.

Vanliga frågor

What does the function return if the date is invalid?

It will return a #VALUE! error.

Relaterade funktioner

YEAR DAY DATE