MONTH
This function extracts the month from a complete date.
Syntax
=MONTH(Date)
=MONTH(Date)
Formatting
Normally the result will be a number, but this can be formatted to show the actual
month by using Format,Cells,Number,Custom and using the code mmm or mmmm.
Normally the result will be a number, but this can be formatted to show the actual
month by using Format,Cells,Number,Custom and using the code mmm or mmmm.
Example
The =MONTH function has been used to calculate the name of the month for your birthday.
The =MONTH function has been used to calculate the name of the month for your birthday.