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