Formula (Extended): $EOMONTH Function
Overview¶
Calculate the last day of the month before or after the specified number of months from the start date.
Syntax¶
Parameters¶
| Parameter | Type | Required | Description |
|---|---|---|---|
| Start Date | Date or date string in yyyy/mm/d format | Required | |
| Month | Half-width numerical value | Required | If a positive number is specified, a date after the start date is returned, and if a negative number is specified, a date before the start date is returned |
Column Usable as Parameters¶
| Parameter | Classification | Numerical Value | Date | Description | Check |
|---|---|---|---|---|---|
| Start date | Yes | No | Yes | Yes | No |
| Month | Yes | Yes | No | Yes | No |
Return Value¶
Date in yyyy/mm/dd format.
Return Value Display Content¶
| Target | Display Content of Return Value |
|---|---|
| Classification (including title, status, manager, owner) | Display return value. |
| Numerical Value (including work volume, progression rate, remaining work volume) | Do not display. |
| Date (including start and completion) | Display return value. If the editor format is "Date and time (minutes)" or "Date and time (seconds)", 00:00:00 will be automatically completed. |
| Description (including content) | Display return value. |
| Check (including lock) | Do not display. |
Usage Example ①¶
Specify parameters by screen column name (name displayed)
Formula¶
Parameters¶
Calculation Result¶
