Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Show blank in cell if

Topic Labels: Formulas
256 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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

image

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

Perfect!
Thank you.
Appreciated.