How to get number of month in Microsoft Excel / How to use MONTH function (formula) in Microsoft Excel

MONTH

Use of MONTH function/formula in Microsoft Excel:

This function in Microsoft Excel return the month from given date in to number such as 1 to 12.

Syntax/Formula:

Syntax of MONTH function in Microsoft Excel is below

=MONTH("date/month/year")

Example:

Step 1: First type any date for Ex. 25-12-1955 in cell B5.

Step 2: Type formula =MONTH(B5)  in cell B8 and press enter.

Note :   (If Cell B5 is blank then this function result is 1).

MONTH