Show blank in cell if

I have a formula field that calculates the difference between {End date} and {Start date}.
image

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

image

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

Perfect!
Thank you.
Appreciated.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.