Ignore negative: Calculate time between dates ignore negative numbers

latheobald89201 ✭✭✭
edited 12/09/19 in Formulas and Functions

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)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!