User Manual

06.20.2025

MANUAL

Formula (Extended): $DAY Function

## Overview Find the number of days for a specified date. ## Syntax ``` $DAY(Date) ``` ## Parameters |Parameter|Type|Required|Description| |:---|:---|:---|:---| |Date|Date or date string in yyyy/mm/dd format|Required|| ### Column Usable as Parameters |Parameter|Classification|Numeric Value|Date|Description|Check| |:---|:---|:---|:---|:---|:---| |Date|Yes|No|Yes|Yes|No| ## Return Value Number of days (1 to 31). ### Return Value Display Content |Target|Display Content of Return Value| |:---|:---| |Classification (including title, status, manager, owner)|Display return value. In the case of a drop-down list with values, the options that match the return value are displayed. | |Numeric Value (including work volume, progression rate, remaining work volume)|Display return value. | |Date (including start and completion) |Do not display. | |Description (including content) |Display return value. | |Check (including lock) |Do not display. | ## Example of use ① Specify parameters by screen column name (name displayed) ### Formula ![image](https://pleasanter.org/binaries/34869087993a42958ce36e0c628f4fd8) ### Parameters ![image](https://pleasanter.org/binaries/44d2d60877b149c683bc8a39d30dfe3d) ### Calculation Result ![image](https://pleasanter.org/binaries/bbcfd236e9384e8cb71b06850be09363)
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.