Explainry Tutorials to Expert in IT

MONTH Function in Excel

Use

The MONTH function returns with the 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 - 2020 Explainry.com | All Rights Reserved