Ignore negative: Calculate time between dates ignore negative numbers

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)

Find more posts tagged with

Formulas

Government

Project Management

Comments

Paul Newcome

You could use something as basic as saying if your current formula is greater than 0, run the formula.

=IF(Current Formula > 0, Current Formula)

=IF(IF([Departure Date]83 - TODAY() < 25, TODAY(), 0) > 0, IF([Departure Date]83 - TODAY() < 25, TODAY(), 0))

Monica Gallegos

Hi Paul,

I have a similar use case, but in this case I'm accounting for the formula to manage through an error if the division in the formula is occurring between two 0's, then the value is No Growth.

=IFERROR(([Column6]78 - [Column5]78) / [Column5]78, "No Growth")

I'd like to expand up on this formula and also return "No Growth" if the growth is a negative number. I tried a couple of different formulas but I'm not successful. Any suggestions/recommendations? thanks, Monica

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.