Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Formula date if

Topic Labels: Formulas
789 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Matthieu_LABERI
6 - Interface Innovator
6 - Interface Innovator

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

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