Description
Use this function to return the month number from a given date as a number between 1 and 12. Supported in Chains.
Use the MONTH function to extract a month number from a date into a cell or to feed a month number into another function such as DATE.
Syntax
MONTH(number)
Inputs
This function has the following arguments:
| Name | Required | Valid input |
|---|---|---|
number |
Yes | A cell reference, an integer date, or a text date in the format DD/MM/YYYY or YYYY/MM/DD. A formula which results in one of these is also acceptable. Text dates must be enclosed in quotation marks. |
Example
Sample data
| A | MONTH result |
|---|---|
| February 1, 2018 | 2 |
| 2019-5-12 | 5 |
| July 4, 2000 | 10/4/2001 |
| 7/19/2003 | 11/19/1995 |
| 12/23/2023 | 10/23/2025 |
Sample formulas
| Formula | Description | Result |
|---|---|---|
=MONTH(A1) |
Returns the month number for the date in cell A1 | 2 |
=MONTH("17/9/2003") |
Returns the month number for the supplied date of 17/9/2003
|
9 |
Notes
- The Workiva platform stores dates as numbers so they can be used in calculations.
By default, January 1, 1900 = 1. - MONTH always returns an integer between 1 and 12.
- If the supplied or referenced date isn't a valid integer date or in the format DD/MM/YYYY or YYYY/MM/DD, MONTH returns the #NUM! error.
- If a date isn't recognized, MONTH will return the #VALUE! error.
- If a supplied text date isn't in quotation marks, MONTH will return the #VALUE! error.
- If the supplied or referenced date has a time value attached (that is, it's not an integer), that portion is ignored. For example, 45332.75 will be treated as 45332.
- Wildcards don't work with this function.
Related functions
DATE
DATEVALUE
DAY
DAYS
DAYS360
EDATE
EOMONTH
MONTH
NETWORKDAYS
NETWORKDAYS.INTL
WEEKDAY
WORKDAY
WORKDAY.INTL
YEAR
YEARFRAC