Then (with a minor mod to my first suggestion), does this work for
you ...
=MAX(DAYS360(if(IsBlank(S24),R24,S24),U24),0)
Rgds,
ScottO
| Thanks for the wake-up call. Been a busy day so far. My fingers
and brain
| are not cooperating. Here is what I need added to OP formula:
|
| R and U are currently totaling max days.
|
| If I put a date in S, I want S and U to total. R will still have
its
| original date. S is a revised date which overrides R. S will be
blank if no
| revision required.
|
| Thanks again.
|
| "ScottO" wrote:
|
| > 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
| >
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
| > | >
| > 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.
| > | >
| > | >
| > | >
| >
| >
| >
