Formula calculating empty dates

[ZENITH_CONSEIL (LANIER FRANCOISE EI ZENITH CONSEIL)]

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

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

I have 2 questions

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

[GCavin (Gilles Cavin)]

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"))