Description
Returns the number of months between two Dates.
Syntax
MONTHDIF(Start Date, End Date)
Arguments
| Argument | Type | Dimensions | Description |
|---|---|---|---|
| Start Date (required) | Date | Any Dimensions | |
| End Date (required) | Date | No Dimension or Dimensions of Date From |
Returns
| Type | Dimensions |
|---|---|
| Integer | Dimensions of argument Start Date |
Examples
| Formula | Result | Description |
|---|---|---|
|
| 0 | There is a 0 month difference between January 1st 2020 and January 31st 2020. |
MONTHDIF(DATE(2020, 01, 31), DATE(2020, 02, 01)) | 1 | There is a 1 month difference between January 31st 2020 and February 1st 2020. |
MONTHDIF(DATE(2020, 01, 1), DATE(2021, 01, 01)) | 12 | There is a 12 months difference between January 1st 2020 and January 1st 2021. |
See also
Related articles: EDATE, MONTH , EOMONTH
More of a hands-on learner?
Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!
