Description
Returns the last day of a month after or before a given date.
Syntax
EOMONTH(Date , Month Offset])
Arguments
| Argument | Type | Dimensions | Description |
|---|---|---|---|
| Date (required) | Date | Any Dimensions | Date to return the last day of. |
| 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 |
Examples
| Formula | Result | Description |
|---|---|---|
|
| November 30th 1986 | The last day of the month of November 28th 1986 is November 30th 1986. |
|
| January 31st 1989 | The month offset is set to 0. The last day of the month of January 18th 1989 is January 31st 1989. |
|
| February 28th 1986 | The month offset is set to 1. The last day of the next month of January 1st 1986 is February 28th 1986. |
|
| March 31st 1985 | The month offset is set to -10. The previous 10 months of January 1st 1986 was in March 1985. The last day is March 31st 1985. |
See also
Excel: EOMONTH
Related articles: EDATE, MONTH, STARTOFMONTH
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!
