Mar 22, 2022 03:10 PM
I have a formula field that calculates the difference between {End date} and {Start date}.
Works fine
If there is no Start Date or no End date I want the cell to be blank instead of NaN
Been trying everything.
HELP!!
Mar 22, 2022 03:16 PM
Mar 22, 2022 03:56 PM
IF(
AND({End Date}, {Start date}),
DATETIME_DIFF({End Date}, {Start date}, "days")
)
Mar 22, 2022 06:49 PM
Perfect!
Thank you.
Appreciated.