Formula (Extended): $MONTH Function
Overview
Find the number of months for a specified date.
Syntax
$MONTH(Date)Parameter
| Parameter | Type | Required | Description |
|---|---|---|---|
| Date | Date or date string in yyyy/mm/dd or yyyy/mm/dd hh:MM:ss format | Required |
Column Usable as Parameters
| Parameter | Classification | Numerical Value | Date | Description | Check |
|---|---|---|---|---|---|
| Date | Yes | No | Yes | Yes | No |
Return Value
Number of months (1-12).
Return Value Display Content
| Target | Display Content of Return Value |
|---|---|
| Classification (including title, status, manager, owner) | Display return value. In the case of a dropdown list with values, the options that match the return value are displayed. |
| Numerical Value (including work volume, progression rate, remaining work volume) | Display return value. |
| Date (including start and completion) | Do not display. |
| Description (including content) | Display the return value. |
| Check (including lock) | Do not display. |
Usage Example ①
Specify parameters by screen column name (name displayed)
