Excel MONTH Formula

This tutorial demonstrates how to use the Excel MONTH Function in Excel to get the month from a date.

MONTH Main function

MONTH Function Overview

The MONTH Function Returns the month as a number (1-12) from a date.

To use the MONTH Excel Worksheet Function, select a cell and type:

month formula syntax

(Notice how the formula inputs appear)

MONTH Function Syntax and Inputs:

Function Arguments ( Inputs ):

serial_number – The date in Excel serial number format or entered as a date with quotations (“s) surround the date. Example: You can not enter 11/12/2015 directly into the cell. Instead you need to enter “11/12/2015” or you would need to use the corresponding serial number: 42320. Alternatively, you can reference a cell with the date 11/12/2015 entered. Excel automatically converts dates stored in cells into serial format (unless the date is entered as text).

 

MONTH Examples

The MONTH Function returns the month number of a date:

Month functionGet Month Name

Using the CHOOSE and MONTH functions, you can also return the month name of a date instead:

Month Choose FunctionDate & Month Functions

Using the DATE and MONTH Functions you can build a new date using the month from the original date:

Date Month functionMONTH in Google Sheets

The MONTH Function works exactly the same in Google Sheets as in Excel:

Month google sheet

MONTH Examples in VBA

You can also use the MONTH function in VBA. Type:
application.worksheetfunction.month(serial_number)
For the function arguments (serial_number, etc.), you can either enter them directly into the function, or define variables to use instead.

Return to the List of all Functions in Excel