MONTH Function - Excel

Overview

The MONTH function in Excel is a useful tool for extracting the month of a date. This function returns the value of a number between 1 and 12.

An example of the MONTH function in Excel

Example:

=MONTH("1/15/2023")

Syntax:

=MONTH(serial_number)

serial_number: This is the date from which you want to extract the month.

Example

In this example, the MONTH function returns the month value from the “3/21/23” date. The final output is 3.

Another example of the MONTH function in Excel

Interactive GSheet