VB,
I cannot understand from your formula how you calculate S (is it maybe
TODAY()-R12?). Anyway, leaving space for this in _your calculation_,
the following formula implements the conditions you describe:
=IF(OR(AND(P12=1,TODAY()-R1230,U12-R1230),AND(P12=2,TODAY()-
R1245,U12-R1245)),_your calculation_,"")
HTH
Kostis Vezerides
On Feb 28, 7:48 pm,
VB wrote:
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