Formula calculating empty dates

I need to add some days to a date.
But this date is most of the time empty.
So I need to implemente that kind of formula :slight_smile:

IF (date IS EMPTY) THEN (display “nothing”) ELSE (diplay date + days).

I have 2 questions :question:

  1. How to test en empty date
  2. How to avoid the “warning icon” that appears automatically ?

Hi @ZENITH_CONSEIL ,

Let’s say you want to add 5 days:

If({Date}="";"";ADD_DAYS({Date},5))

or if you want the date formatted as YYYY-MM-DD:

If({Date}="";"";FORMAT_DATE(ADD_DAYS({Date},5),"YYYY-MM-DD"))
1 Like