software

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.

One way that ought to give you what you want ...
=MAX(DAYS360(R24,if(IsBlank(S24),U24,S24)),0)
Rgds,
ScottO

quot;roy.okinawaquot; gt; 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.
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

quot;ScottOquot; wrote:

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

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 quot;... if I put a date in S24 ... I want the
formula to total the days between R24 and S24quot;, but in 2nd post you
say quot;... once a date is input in S, then S and U should total the
daysquot;.
From the 1st post I thought you what you wanted was quot;R to U, unless
there was an entry in S in which case it should be R to Squot;.
Please clarify.
Rgds,
ScottO

quot;roy.okinawaquot; gt; 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
|
| quot;ScottOquot; wrote:
|
| gt; One way that ought to give you what you want ...
| gt; =MAX(DAYS360(R24,if(IsBlank(S24),U24,S24)),0)
| gt; Rgds,
| gt; ScottO
| gt;
| gt; quot;roy.okinawaquot; gt; wrote in
message
| gt; ...
| gt; | Have this formula: =MAX(DAYS360(R24,U24),0)
| gt; |
| gt; | Now I need to add this:
| gt; |
| gt; | Even though this is totaling the days bewtween R24 and U24, if
I
| gt; put a date
| gt; | in S24 (this would override U24), I want the formula to total
the
| gt; days
| gt; | between R24 and S24.
| gt; |
| gt; | I need to keep the date in U24. It is the original work date.
S24
| gt; would be
| gt; | a revised date.
| gt;
| gt;
| gt;
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.

quot;ScottOquot; wrote:

gt; Sorry Roy, but I'm having trouble understanding the requirement.
gt; If you look at your explanation in your first posting and the
gt; explanation in your second posting they seem (to me) to be
gt; contradictory.
gt; In 1st post you said quot;... if I put a date in S24 ... I want the
gt; formula to total the days between R24 and S24quot;, but in 2nd post you
gt; say quot;... once a date is input in S, then S and U should total the
gt; daysquot;.
gt; From the 1st post I thought you what you wanted was quot;R to U, unless
gt; there was an entry in S in which case it should be R to Squot;.
gt; Please clarify.
gt; Rgds,
gt; ScottO
gt;
gt; quot;roy.okinawaquot; gt; wrote in message
gt; ...
gt; | This still totals the days between R and U.
gt; |
gt; | Even though U has a date, once a date is input in S, then S and U
gt; should
gt; | total the days. S will not always have a date
gt; |
gt; | quot;ScottOquot; wrote:
gt; |
gt; | gt; One way that ought to give you what you want ...
gt; | gt; =MAX(DAYS360(R24,if(IsBlank(S24),U24,S24)),0)
gt; | gt; Rgds,
gt; | gt; ScottO
gt; | gt;
gt; | gt; quot;roy.okinawaquot; gt; wrote in
gt; message
gt; | gt; ...
gt; | gt; | Have this formula: =MAX(DAYS360(R24,U24),0)
gt; | gt; |
gt; | gt; | Now I need to add this:
gt; | gt; |
gt; | gt; | Even though this is totaling the days bewtween R24 and U24, if
gt; I
gt; | gt; put a date
gt; | gt; | in S24 (this would override U24), I want the formula to total
gt; the
gt; | gt; days
gt; | gt; | between R24 and S24.
gt; | gt; |
gt; | gt; | I need to keep the date in U24. It is the original work date.
gt; S24
gt; | gt; would be
gt; | gt; | a revised date.
gt; | gt;
gt; | gt;
gt; | gt;
gt;
gt;
gt;

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

quot;roy.okinawaquot; gt; wrote in message
...
| 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.
|
| quot;ScottOquot; wrote:
|
| gt; Sorry Roy, but I'm having trouble understanding the requirement.
| gt; If you look at your explanation in your first posting and the
| gt; explanation in your second posting they seem (to me) to be
| gt; contradictory.
| gt; In 1st post you said quot;... if I put a date in S24 ... I want the
| gt; formula to total the days between R24 and S24quot;, but in 2nd post
you
| gt; say quot;... once a date is input in S, then S and U should total the
| gt; daysquot;.
| gt; From the 1st post I thought you what you wanted was quot;R to U,
unless
| gt; there was an entry in S in which case it should be R to Squot;.
| gt; Please clarify.
| gt; Rgds,
| gt; ScottO
| gt;
| gt; quot;roy.okinawaquot; gt; wrote in
message
| gt; ...
| gt; | This still totals the days between R and U.
| gt; |
| gt; | Even though U has a date, once a date is input in S, then S and
U
| gt; should
| gt; | total the days. S will not always have a date
| gt; |
| gt; | quot;ScottOquot; wrote:
| gt; |
| gt; | gt; One way that ought to give you what you want ...
| gt; | gt; =MAX(DAYS360(R24,if(IsBlank(S24),U24,S24)),0)
| gt; | gt; Rgds,
| gt; | gt; ScottO
| gt; | gt;
| gt; | gt; quot;roy.okinawaquot; gt; wrote in
| gt; message
| gt; | gt; ...
| gt; | gt; | Have this formula: =MAX(DAYS360(R24,U24),0)
| gt; | gt; |
| gt; | gt; | Now I need to add this:
| gt; | gt; |
| gt; | gt; | Even though this is totaling the days bewtween R24 and U24,
if
| gt; I
| gt; | gt; put a date
| gt; | gt; | in S24 (this would override U24), I want the formula to
total
| gt; the
| gt; | gt; days
| gt; | gt; | between R24 and S24.
| gt; | gt; |
| gt; | gt; | I need to keep the date in U24. It is the original work
date.
| gt; S24
| gt; | gt; would be
| gt; | gt; | a revised date.
| gt; | gt;
| gt; | gt;
| gt; | gt;
| gt;
| gt;
| gt;
Thanks.

quot;ScottOquot; wrote:

gt; Then (with a minor mod to my first suggestion), does this work for
gt; you ...
gt; =MAX(DAYS360(if(IsBlank(S24),R24,S24),U24),0)
gt; Rgds,
gt; ScottO
gt;
gt; quot;roy.okinawaquot; gt; wrote in message
gt; ...
gt; | Thanks for the wake-up call. Been a busy day so far. My fingers
gt; and brain
gt; | are not cooperating. Here is what I need added to OP formula:
gt; |
gt; | R and U are currently totaling max days.
gt; |
gt; | If I put a date in S, I want S and U to total. R will still have
gt; its
gt; | original date. S is a revised date which overrides R. S will be
gt; blank if no
gt; | revision required.
gt; |
gt; | Thanks again.
gt; |
gt; | quot;ScottOquot; wrote:
gt; |
gt; | gt; Sorry Roy, but I'm having trouble understanding the requirement.
gt; | gt; If you look at your explanation in your first posting and the
gt; | gt; explanation in your second posting they seem (to me) to be
gt; | gt; contradictory.
gt; | gt; In 1st post you said quot;... if I put a date in S24 ... I want the
gt; | gt; formula to total the days between R24 and S24quot;, but in 2nd post
gt; you
gt; | gt; say quot;... once a date is input in S, then S and U should total the
gt; | gt; daysquot;.
gt; | gt; From the 1st post I thought you what you wanted was quot;R to U,
gt; unless
gt; | gt; there was an entry in S in which case it should be R to Squot;.
gt; | gt; Please clarify.
gt; | gt; Rgds,
gt; | gt; ScottO
gt; | gt;
gt; | gt; quot;roy.okinawaquot; gt; wrote in
gt; message
gt; | gt; ...
gt; | gt; | This still totals the days between R and U.
gt; | gt; |
gt; | gt; | Even though U has a date, once a date is input in S, then S and
gt; U
gt; | gt; should
gt; | gt; | total the days. S will not always have a date
gt; | gt; |
gt; | gt; | quot;ScottOquot; wrote:
gt; | gt; |
gt; | gt; | gt; One way that ought to give you what you want ...
gt; | gt; | gt; =MAX(DAYS360(R24,if(IsBlank(S24),U24,S24)),0)
gt; | gt; | gt; Rgds,
gt; | gt; | gt; ScottO
gt; | gt; | gt;
gt; | gt; | gt; quot;roy.okinawaquot; gt; wrote in
gt; | gt; message
gt; | gt; | gt; ...
gt; | gt; | gt; | Have this formula: =MAX(DAYS360(R24,U24),0)
gt; | gt; | gt; |
gt; | gt; | gt; | Now I need to add this:
gt; | gt; | gt; |
gt; | gt; | gt; | Even though this is totaling the days bewtween R24 and U24,
gt; if
gt; | gt; I
gt; | gt; | gt; put a date
gt; | gt; | gt; | in S24 (this would override U24), I want the formula to
gt; total
gt; | gt; the
gt; | gt; | gt; days
gt; | gt; | gt; | between R24 and S24.
gt; | gt; | gt; |
gt; | gt; | gt; | I need to keep the date in U24. It is the original work
gt; date.
gt; | gt; S24
gt; | gt; | gt; would be
gt; | gt; | gt; | a revised date.
gt; | gt; | gt;
gt; | gt; | gt;
gt; | gt; | gt;
gt; | gt;
gt; | gt;
gt; | gt;
gt;
gt;
gt;