Formula Help

Brenda Gonzales

Hi, 

Need help combining these two formulas to calculate the # of days open from the date of entry. Not to include "Solution complete" or "Solution identified and agreed upon". 

=IF(NOT(Status@row = "Solution Complete"), (TODAY() - Date@row), "")

=IF(NOT(Status@row = "Solution identified and agreed upon"), (TODAY() - Date@row), "")

Thank you 

Paul Newcome

There are a couple of ways you can do this. You can nest them together like so:

 

=IF(NOT(.................), TODAY() - Date@row, IF(NOT(.................), TODAY() - Date@row, ""))

.

But since they have the same results, you can also use an AND function like this:

 

=IF(AND(NOT(................), NOT(..............)), TODAY() - Date@row, "")

Brenda Gonzales

Thank you , the last combined formula worked. 

Paul Newcome

Excellent! Happy to help!