=MONTHLASTDAY
The =MONTHLASTDAY() function allows you to extract the numerical last day of the month of the provided date. Optionally allows you to add or subtract days from the last day of the month.
Syntax
Section titled “Syntax”=MONTHLASTDAY(DateValue; OptionalAddOrSubtractDay)Parameters
Section titled “Parameters”-
DateValue – The date or date field token used to determine the month.
-
OptionalAddOrSubtractDay (optional) – A number to add to or subtract from the last day of the month.
-
Use a positive number to add days.
-
Use a negative number to subtract days.
-
How It Works
Section titled “How It Works”-
Determines the last day of the month for the provided date.
-
Applies the optional add or subtract value if provided.
-
Returns the resulting numeric day.
Usage Notes
Section titled “Usage Notes”-
Formula functions are case sensitive and must be written in ALL CAPS.
-
The date must be in a valid format recognized by the system.
-
Field tokens containing dates can be used instead of hard-coded values.
-
Adding or subtracting days may produce a number outside the valid day range of the month; use with care.
-
Useful for calculating deadlines, offsets, or month-end logic in workflows.
Example
Section titled “Example”=MONTHLASTDAY(2024-12-24; -1)Returns: 30
Explanation: The result is 30 because December has 31 days and we provided the optional second parameter to subtract 1 from 31 so the result is 30.
Keywords
Section titled “Keywords”MONTHLASTDAY, last day of month, date function, extract day, month-end calculation, workflow formulas, formula function