Sorry Roy, but I'm having trouble understanding the requirement.
If you look at your explanation in your first posting and the
explanation in your second posting they seem (to me) to be
contradictory.
In 1st post you said "... if I put a date in S24 ... I want the
formula to total the days between R24 and S24", but in 2nd post you
say "... once a date is input in S, then S and U should total the
days".
From the 1st post I thought you what you wanted was "R to U, unless
there was an entry in S in which case it should be R to S".
Please clarify.
Rgds,
ScottO

"roy.okinawa" wrote in message
...
| This still totals the days between R and U.
|
| Even though U has a date, once a date is input in S, then S and U
should
| total the days. S will not always have a date
|
| "ScottO" wrote:
|
| 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.
|
|
|