Return to List of Excel Functions

MONTH Function Examples – Excel, VBA, & Google Sheets

Download Example Workbook

Download the example workbook

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

Month Formula Main


MONTH Examples

The MONTH Function returns the month number (1-12) 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:
For the function arguments (serial_number, etc.), you can either enter them directly into the function, or define variables to use instead.