MONTH Function Examples – Excel, VBA, & Google Sheets

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:

AutoMacro - VBA Code Generator

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

Excel Practice Worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!