Skip to main content

Show blank in cell if

  • March 22, 2022
  • 3 replies
  • 31 views

Forum|alt.badge.img+2

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

3 replies

Forum|alt.badge.img+2
  • Author
  • Known Participant
  • March 22, 2022


Kamille_Parks11
Forum|alt.badge.img+27


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

Forum|alt.badge.img+2
  • Author
  • Known Participant
  • March 23, 2022

Perfect!
Thank you.
Appreciated.