Look At Two Dates
One way that ought to give you what you want ...
=MAX(DAYS360(R24,if(IsBlank(S24),U24,S24)),0)
Rgds,
ScottO
"roy.okinawa" wrote in message
...
| Have this formula: =MAX(DAYS360(R24,U24),0)
|
| Now I need to add this:
|
| Even though this is totaling the days bewtween R24 and U24, if I
put a date
| in S24 (this would override U24), I want the formula to total the
days
| between R24 and S24.
|
| I need to keep the date in U24. It is the original work date. S24
would be
| a revised date.
|