Help

Show blank in cell if

Topic Labels: Formulas
411 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Ed_Cooper
6 - Interface Innovator
6 - Interface Innovator

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

3 Replies 3
Ed_Cooper
6 - Interface Innovator
6 - Interface Innovator

image

IF(
   AND({End Date}, {Start date}),
   DATETIME_DIFF({End Date}, {Start date}, "days")
)
Ed_Cooper
6 - Interface Innovator
6 - Interface Innovator

Perfect!
Thank you.
Appreciated.