Formula date if

+5

Hi,
I need help from your brain because mine is out for this problem !

Actually i have this formula :

IF(IS_SAME({Date d’envoi}, TODAY(), ‘day’), ‘YES’)

To this formule i want to add 2 things :
if the date is after today add “AFTER”
if the date is before today add “BEFORE”

Finally, i need to have 3 conditions :
YES if today
AFTER if the date is after today
BEFORE if the date is before today

Thank’s for your help !

Matthieu

+27

IF(IS_SAME({Date d’envoi}, TODAY(), 'day'), 'YES',
IF({Date d’envoi} > TODAY(), 'AFTER', 
IF({Date d’envoi} < TODAY(), 'BEFORE')))

Sign up