User Manual

10.03.2024

MANUAL

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 ``` $EOMONTH(Start Date, Month) ``` ## 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 ![image](https://pleasanter.org/binaries/584a9ee5c70d498eb1e79076e0e4760e) ### Parameters ![image](https://pleasanter.org/binaries/95da73396b694643aa6f0f21b2667172) ### Calculation Result ![image](https://pleasanter.org/binaries/720a13de77a147c7a2620d861ac94850)
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.