Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Formula date if

Topic Labels: Formulas
189 1
Showing results for 
Search instead for 
Did you mean: 

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 !


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