Returns the month of a date represented by a serial number.
Cú pháp
MONTH(serial_number)Đối số
serial_numberbắt buộc
The date of the month you are trying to find.
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")→5Extracts the month from May 15, 2023.
Select a cell
Click on the cell where you want to display the month.
Enter the formula
Type =MONTH(A1) where A1 contains the date, then press Enter.
It will return a #VALUE! error.