Description
Used to return the serial number of a month within the year for the given date. The MONTH function can be useful in various nested functions and can provide input for functions while excel modeling.
Remember MONTH function does not calculate the number of months between two dates, instead DATEDIF function is used.
=MONTH(serial_number)
The MONTH function syntax has the following argument:
- Serial_Number Required.
The date of the month you are trying to find.
Note: Avoid directly punching dates into Excel function, instead of either use DATE function or put date within inverted commas (“”) in this sequence i.e. Month/date/year. Otherwise excel will read the date as ZERO.