MONTH takes just oneargument,serial_number, which must be a validExcel date.
Dates can be supplied to the MONTH function as text (e.g.
“13-Aug-2021”) or as native Excel dates, which arelarge serial numbers.
The MONTH function will “reset” every 12 months (like a calendar).
To work with month durations larger than 12, use a formula tocalculate months between dates.
The MONTH function returns anumber.
If you need a month’sname,see this example.
See below for more examples of formulas that use the MONTH function.
Note:dates are serial numbersin Excel, and begin on January 1, 1900.
Dates before 1900 are not supported.
To display date values in a human-readable date format, apply thenumber formatof your choice.
