Excel Formula: Get Month from Date

To get the month value shown as number (1-12) from a given date in Excel, you can use the MONTH function to handle it.

If you want to follow along with this tutorial, please download the example spreadsheet.

Generic formula:

Syntaxt and Arguments

Return Value

The formula returns a numeric value 1-12.

How this formula works

To get the month value in the date of cell B3, please use the formula as below:

Or directly use the date

Press Enter key to get the month value.

Explanation

MONTH function: gets the month as integer number (1 to 12) from date.

Relative Formulas

• Get day name from date
  In this tutorial, it provides formulas to return the day name from the given date in Excel.
• Get fiscal year from date
  This tutorial, it provides a formula to quickly find the fiscal year from a date in Excel
• Get day name from given date
  This tutorial talks about how to use formula to get the day name such as Monday,Tuesday based on the given date.
• Create weekly date range
  In this tutorial, it provides a formula to quickly get the weekly date range in Excel.

Relative Functions

• Excel DATE Function
  Create date with year, month and day
• Excel YEAR Function
  Returns the year of date in 4-digit serial number format
• Excel MONTH Function
  The MONTH is used to get the month as integer number (1 to 12) from date
• Excel DAY Function
  DAY function gets the day as a number (1 to 31) from a date
• Excel NOW Function
  Get the current time and date