V
VB
I am trying to write a conditional formula that calculates the number of days
outstanding, as described below. Here are the pertinent column designations:
Column P = Priority level (1 or 2)
Column R = Date Assigned
Column U = Date Closed
Column V = Status (Open or Closed)
Column S = Days Outstanding
If Column P is 1, and today is more than 30 days past Column R, and Column U
is more than 30 days past Column R, calculate Column S, BUT
If Column P is 2, and today is more than 45 days past Column R, and Column U
is more than 45 days past Column R, calculate Column S
..
So far, this is what I’ve come up with:
=IF(ISNONTEXT(U12),IF(AND(TODAY()>=(R12+30),P12=1),TODAY()-R12,IF(AND(TODAY()>=(R12+45),P12=2),TODAY()-R12)))
Thanks to anyone who can help. I don’t even know if what I’m trying to
accomplish is possible.
--VB
outstanding, as described below. Here are the pertinent column designations:
Column P = Priority level (1 or 2)
Column R = Date Assigned
Column U = Date Closed
Column V = Status (Open or Closed)
Column S = Days Outstanding
If Column P is 1, and today is more than 30 days past Column R, and Column U
is more than 30 days past Column R, calculate Column S, BUT
If Column P is 2, and today is more than 45 days past Column R, and Column U
is more than 45 days past Column R, calculate Column S
..
So far, this is what I’ve come up with:
=IF(ISNONTEXT(U12),IF(AND(TODAY()>=(R12+30),P12=1),TODAY()-R12,IF(AND(TODAY()>=(R12+45),P12=2),TODAY()-R12)))
Thanks to anyone who can help. I don’t even know if what I’m trying to
accomplish is possible.
--VB