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 Ive 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 dont even know if what Im trying to
accomplish is possible.

--VB