What is the use of MONTH function?

Returns the month of a date.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

BROWSE ALL TEMPLATES

50+ Project Management Templates Pack
Excel PowerPoint Word

VIEW DETAILS

Advanced Project Plan & Portfolio Template
Excel Template

VIEW DETAILS

Ultimate Project Management Template
Excel Template

VIEW DETAILS

20+ Excel Project Management Pack
Excel Templates

VIEW DETAILS

20+ PowerPoint Project Management Pack
PowerPoint Templates

VIEW DETAILS

10+ MS Word Project Management Pack
Word Templates

VIEW DETAILS


Note: The month is returned as an integer in the range 1 to 12

What is the syntax of MONTH function?

MONTH Function in Excel-syntax

MONTH(serial_number)

Where Serial_number: is the date of the month you want to find.

MONTH Function in Excel – Examples

MONTH Function in Excel- Example

Reference:

Please refer the below article for more Date & Time Excel functions.
Date & Time Excel Formulas

Please refer the below article for more Excel Functions.
Excel Formulas | Home

LIMITED TIME OFFER - Get it Now!
Advanced Project Plan Excel Template

 
Related Resource External VBA Reference