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:
| MONTH(date) |
Syntaxt and Arguments
| Date: the date you want to get the month. |
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:
| =MONTH(B3) |
Or directly use the date
| =MONTH("3/12/2021") |
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
The Best Office Productivity Tools
Kutools for Excel - Helps You To Stand Out From Crowd
Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...
Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)
- One second to switch between dozens of open documents!
- Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
- Increases your productivity by 50% when viewing and editing multiple documents.
- Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.
