Home » Posts

Get month from date

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.

April 14, 2025 · 1 min · 45 words · Matthew Richardson

Table of Contents

Explanation

The MONTH function takes just one argument, the date from which to extract the month.

In the example shown, the formula is:

where B4 contains the date January 5, 2016.

The MONTH function returns the number 1 representing the month( January) of the date.

Excel formula: Get month name from date

Excel formula: Get year from date

Excel formula: Get day from date

Excel MONTH function

Excel DATE function

Explanation#

Explanation