MONTH Function Examples – Excel, VBA, & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 9, 2023
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.

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

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

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to List of Excel Functions