The MONTH function in Excel returns the month component of a specified date as a number between 1-12.

Syntax:

=MONTH(serial_number)

Arguments

serial_number – (required) The date that contains the month you want to extract.

MONTH Function Usage Examples:

Let’s look at the following example that shows how the month is removed from a date value in Excel.

Here are some other usage examples. Excel automatically pulls out the month from a date. When other components are present, such as hours, seconds, and days, Excel ignores these figures. Review the example below.

month function
MONTH Function Examples

Usage Errors

#VALUE! error – The serial_number is not a valid Excel date.

Leave a Reply

CUMIPMT Function

How much interested have I paid? The CUMIPMT Function in Excel is a financial function designed to calculate and return

Read More »

YEAR Function

The YEAR function in Excel returns a 4-digit number representing the year component of date. This function allows you to

Read More »

If Function

The IF Function in excel is a logical test that can be run using specific conditions. This logical test returns

Read More »
Scroll to Top