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.
Syntaxt and Arguments
|Date: the date you want to get the month.|
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.
MONTH function: gets the month as integer number (1 to 12) from date.
- 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.
- 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