Description
Adds or substracts a given number of months to the given Date.
Syntax
EDATE(Date [, Month Offset])
Arguments
Argument | Type | Dimensions | Description |
|---|---|---|---|
Date (required) | Date | Any Dimensions | Date to add or substract. |
Month Offset (required) | Integer | No Dimension or Dimensions of argument Date | Offset the given argument Date by a number of months. By default, the offset is equivalent to 0. |
Returns
Type | Dimensions |
|---|---|
Date | Dimensions of argument Date |
If a corresponding day does not exist in the target month, the last day of the month will be used instead.
Examples
Formula | Result | Description |
|---|---|---|
| February 2nd 2021 | Two months added to December 2nd 2020 is February 2nd 2021. |
| February 28th 2021 | Two months added to December 30th 2020 is February 28th 2021. February 30th does not exist, so the last day of the month is used instead. |
See also
Excel: EDATE
Related articles: DATE
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!