Formula (Extended): $DAYS Function

Dec 6, 2023Jun 7, 2024

Overview¶

Calculate the number of days between two dates.

$DAYS(Completion Date, Start Date)

Parameter	Type	Required	Description
Completion Date	Date or date string in yyyy/mm/d format	Required	Error if start date > completion date.
Start Date	Date or date string in yyyy/mm/d format	Required	Error if start date > completion date.

Parameter	Classification	Numerical Value	Date	Description	Check
Completion Date	Yes	No	Yes	Yes	No
Start date	Yes	No	Yes	Yes	No

Number of days.

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, display the options that match the return value
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 return value.
Check (including lock)	Do not display.