I am running a formula to calculate the days between a start date and today(), if the number is less than 25 then it inserts today's date in a cell. That cell is then used to trigger an email to a user for action.
If the start date is in the past the calculated days between is a negative. I want the formula to ignore the number if it is a negative and not trigger the email to the user. ie if the date is in the past don't insert todays date.
=IF([Departure Date]83 - TODAY() < 25, TODAY(), 0)