Excel formula: Get month from date

Generic formula

=MONTH(date)

Summary

If you need to extract the month from a date, you can use the MONTH function. In the generic form of the formula above, the date must be in a form that Excel recognizes as a valid date.

Explanation

The MONTH function takes just one argument, the date from which to extract the month. In the example shown, the formula is:

=MONTH(B4)

where B4 contains the dateJanuary 5, 2016. The MONTH function returns the number 1 representing the month( January) of the date.

Note that you can use MONTH to extract the month from a day entered as text:

=MONTH("1/5/2016")

However, using text for dates can produce unpredictable results on computers using different regional date settings. It's better (and more flexible) to supply an address to a cell that already contains a valid date.

Get month name

To extract the month name from a date, you can use the TEXT function, as described in this example.

Author

Dave Bruns

Related formulas

Get month name from date

Do you want to convert the date into a month name? If you want to convert the date value to a text value, you can use the TEXT function with a custom number format like "mmmm", or "mmm". In the example shown, the formula in cell C4 is: = TEXT ( B4...

Get year from date

The YEAR function takes just one argument, the date from which you want to extract the year. In the example, the formula is: = YEAR ( B4 ) B4 contains a date value for January 5, 2016. The YEAR function returns the number 2016 representing the year...

Get day from date

The DAY function takes just one argument, the date from which you want to extract the day. In the example, the formula is: = DAY ( B5 ) B5 contains a date value for January 5, 2016. The DAY function returns the number 5 representing the day...

Related functions

Excel MONTH Function

The Excel MONTH function extracts the month from a given date as number between 1 to 12. You can use the MONTH function to extract a month number from a date into a cell, or to feed a month number into another function like the...

Excel DATE Function

The Excel DATE function creates a valid date from individual year, month, and day components. The DATE function is useful for assembling dates that need to change dynamically based on other values in a worksheet.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.