MONTH Function in Excel

Home/Excel Formulas/MONTH Function in Excel

What is the use of MONTH function?

Returns the month of a date.


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

By |June 1st, 2013|Excel Formulas|0 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

Leave A Comment