Skip to main content

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!!


IF(
   AND({End Date}, {Start date}),
   DATETIME_DIFF({End Date}, {Start date}, "days")
)

Perfect!
Thank you.
Appreciated.

Terms & ConditionsAccessibility statement