MONTH Function in Excel

Use

The MONTH function returns with a month number from 1 to 12.

Syntax

MONTH(serial_number)

where (serial_number) is a valid date in Excel format.

Example

Formula:

Result:

Copy and paste the formula in other cells.

 

Common Error

If you enter the date in text format or in an unrecognized format, Excel will show the #VALUE! error.

Get month name from date

You may also get month name by using TEXT function.

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved