MONTH function

MONTH(date) returns the month of the year of date. Date can either be a serial date number or a date string.

Example

MONTH("08.23.88") returns 8 (date format MM.DD.YYYY)

Calculator

Related functions

• DAY function
• YEAR function
• List of Date and time functions