Show blank in cell if

Ask the community Formulas
#1

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

#2

image

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

Perfect!
Thank you.
Appreciated.

#5

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