Formula (Extended): $DATE Function

Dec 5, 2023Jun 12, 2024

Overview¶

Find the date for the specified year, month, and day.

$DATE(Year, Month, Day)

Parameter	Type	Required	Description
Year	4-digit half-width numerical value	Required	Specify 1900 or higher. An error occurs if the number is less than 1900. An error occurs if the string is not a half-width numerical value.
Month	Half-width numerical value	Required	If a value other than 1 to 12 is entered, the past or future month is calculated using the input value. An error occurs if the string is not a half-width numerical value. A blank is considered to be 0.
Day	Half-width numerical value	Required	If a value other than 1 to 31 is entered, the past or future day is calculated using the input value. An error occurs if the string is not a half-width numerical value. A blank is considered to be 0.

Parameter	Classification	Numerical Value	Date	Description	Check
Year	Yes	Yes	No	Yes	No
Month	Yes	Yes	No	Yes	No
Day	Yes	Yes	No	Yes	No

Date in yyyy/mm/dd format.

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.