Jun 04 2019 04:55 AM
I have a formula which looks at a date in column B and returns how many days from that date - thi s formula is =Today()-B3, I have another column with Text which states Major Overdue or other text. I would like to change my formula that is =Today()-B3 so that it looks at the B column and at the text column. I would like it to return the number of days since the date in B column as it currently does, unless it states Major Overdue in the text column, in which case it would put in 30 - is this possible and does this make sense
Jun 04 2019 05:31 AM
@SPearson1973 , if your text is in C3 that could be
=(30-TODAY()+B3)*(C3="Major Overdue")+TODAY()-B3
or
=IF(C3="Major Overdue",30,TODAY()-B3)
Jun 04 2019 05:55 AM
Jun 04 2019 05:59 AM
Thank you so much, can i add an or to this so if C3 is Major Overdue or Overdue to make it 30?
Jun 04 2019 11:48 AM
@SPearson1973 , yes, sure, you may wrap both options with OR, alternatively use
=IF( ISNUMBER(SEARCH("Overdue",C3)), 30, TODAY()-B3)
Condition returns TRUE if the word Overdue will be within any text in C3.
Same with the other formulas above.
Jun 04 2019 11:58 AM