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(B3)

Month functionGet Month Name

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

=CHOOSE(MONTH(B3),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")

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(2020,MONTH(B3),31)

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.