MONTH Function Examples – Excel, VBA, & Google Sheets

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

MONTH Examples

The MONTH Function returns the month number (1-12) of a date:

=MONTH(B3)

Get 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")

Date & 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)

MONTH in Google Sheets

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

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.