Hey Guyz!

Since Max and Ron have been so helpful, I'll throw out a more complex
formula. My best friend is a senior software engineer, however since he's got
married, he hasn't had a lot of time for my spreadsheet problems. He created
the spreadsheet for me, but I've been left to my own devices since he's taken
his wife.

Here is another formula I am working with (which works):

=IF(OR(AA7<"",OR(AND(TODAY()AG7,(AN7="AC
Initiated")))),IF(AND(TODAY()AG7,(AN7="AC Initiated")),IF(AP7="","Check AC
Status",IF(AND(TODAY()(EDATE(AP7,6)),OR(AN7="AC Initiated")),"Re-Check AC
Status","")),IF(AND(TODAY()EDATE(AA7,12),OR(AN7=" Referred to
TX")),IF(AL7="","Eval Before
RF",IF(AND(TODAY()(EDATE(AL7,6)),OR(AN7="Referr ed to Tx")),"Confirm AC
Follow
Through","")),"")),IF(AL7<"",IF(AND(TODAY()EDATE (AL7,6),OR(AN7="Referred to
Tx")),"Confirm AC Follow Through",""),""))

The following are additional requirements I want to encorporate into the
above "beast of a formula":

A flag entitled "Update Eval Before Hearing" should appear if more than a
year elapses (from the date that the evaluation was posted in Row AL). To
clarify, the "Confirm AC Follow Through" flag appears if more than 6 months ,
but less than 12 months has elapsed (which the above formula does without
difficulty), and the new "Update Eval Before Hearing", should appear if more
than 1 year elapses. The addition to the formula also presumes that a Hearing
date was posted in Row AA.

I tried to integrate the following piece of logic into the above formula (to
address the above requirement), but it didn't work:

IF(AND(TODAY()(EDATE(AL7,12)),OR(AN7="Referred to Tx")),IF(AA7<"","Update
Eval Before Hearing","")),""))

I realize that this is a very long and detailed formula, so I understand if
it's asking too much............

Happy 4th!

Dan

Without studying your formula in any detail, and based solely on your
description of the addition you want and the fact that the existing formula
works correctly, I would guess that putting this (don't miss the comma at
the end)...

IF(TODAY()EDATE(AL7,12),"Update Eval Before Hearing",

in front of the formula you now have (that is, after the equal sign but
before the first IF) and placing a closing parenthesis at the end of your
existing formula, would do what you want.

Rick



"Dan the Man" wrote in message
...
Hey Guyz!

Since Max and Ron have been so helpful, I'll throw out a more complex
formula. My best friend is a senior software engineer, however since he's
got
married, he hasn't had a lot of time for my spreadsheet problems. He
created
the spreadsheet for me, but I've been left to my own devices since he's
taken
his wife.

Here is another formula I am working with (which works):

=IF(OR(AA7<"",OR(AND(TODAY()AG7,(AN7="AC
Initiated")))),IF(AND(TODAY()AG7,(AN7="AC Initiated")),IF(AP7="","Check
AC
Status",IF(AND(TODAY()(EDATE(AP7,6)),OR(AN7="AC Initiated")),"Re-Check AC
Status","")),IF(AND(TODAY()EDATE(AA7,12),OR(AN7=" Referred to
TX")),IF(AL7="","Eval Before
RF",IF(AND(TODAY()(EDATE(AL7,6)),OR(AN7="Referr ed to Tx")),"Confirm AC
Follow
Through","")),"")),IF(AL7<"",IF(AND(TODAY()EDATE (AL7,6),OR(AN7="Referred
to
Tx")),"Confirm AC Follow Through",""),""))

The following are additional requirements I want to encorporate into the
above "beast of a formula":

A flag entitled "Update Eval Before Hearing" should appear if more than a
year elapses (from the date that the evaluation was posted in Row AL). To
clarify, the "Confirm AC Follow Through" flag appears if more than 6
months ,
but less than 12 months has elapsed (which the above formula does without
difficulty), and the new "Update Eval Before Hearing", should appear if
more
than 1 year elapses. The addition to the formula also presumes that a
Hearing
date was posted in Row AA.

I tried to integrate the following piece of logic into the above formula
(to
address the above requirement), but it didn't work:

IF(AND(TODAY()(EDATE(AL7,12)),OR(AN7="Referred to
Tx")),IF(AA7<"","Update
Eval Before Hearing","")),""))

I realize that this is a very long and detailed formula, so I understand
if
it's asking too much............

Happy 4th!

Dan

Thanks Rick. That got me closer, but still not 100%. With your suggestion,
the "Update Eval Before Hearing" flag does appear if the date in Cell AL7 is
greater than 12 months, however if I enter a date under 6 months, the flag
"Confirm AC follow Through" still shows up. That flag should only appear (per
the formula below) if more than 6 months, but less than 12 months has
elapsed. I appreciate your suggestion.

Dan

"Rick Rothstein (MVP - VB)" wrote:

Without studying your formula in any detail, and based solely on your
description of the addition you want and the fact that the existing formula
works correctly, I would guess that putting this (don't miss the comma at
the end)...

IF(TODAY()EDATE(AL7,12),"Update Eval Before Hearing",

in front of the formula you now have (that is, after the equal sign but
before the first IF) and placing a closing parenthesis at the end of your
existing formula, would do what you want.

Rick



"Dan the Man" wrote in message
...
Hey Guyz!

Since Max and Ron have been so helpful, I'll throw out a more complex
formula. My best friend is a senior software engineer, however since he's
got
married, he hasn't had a lot of time for my spreadsheet problems. He
created
the spreadsheet for me, but I've been left to my own devices since he's
taken
his wife.

Here is another formula I am working with (which works):

=IF(OR(AA7<"",OR(AND(TODAY()AG7,(AN7="AC
Initiated")))),IF(AND(TODAY()AG7,(AN7="AC Initiated")),IF(AP7="","Check
AC
Status",IF(AND(TODAY()(EDATE(AP7,6)),OR(AN7="AC Initiated")),"Re-Check AC
Status","")),IF(AND(TODAY()EDATE(AA7,12),OR(AN7=" Referred to
TX")),IF(AL7="","Eval Before
RF",IF(AND(TODAY()(EDATE(AL7,6)),OR(AN7="Referr ed to Tx")),"Confirm AC
Follow
Through","")),"")),IF(AL7<"",IF(AND(TODAY()EDATE (AL7,6),OR(AN7="Referred
to
Tx")),"Confirm AC Follow Through",""),""))

The following are additional requirements I want to encorporate into the
above "beast of a formula":

A flag entitled "Update Eval Before Hearing" should appear if more than a
year elapses (from the date that the evaluation was posted in Row AL). To
clarify, the "Confirm AC Follow Through" flag appears if more than 6
months ,
but less than 12 months has elapsed (which the above formula does without
difficulty), and the new "Update Eval Before Hearing", should appear if
more
than 1 year elapses. The addition to the formula also presumes that a
Hearing
date was posted in Row AA.

I tried to integrate the following piece of logic into the above formula
(to
address the above requirement), but it didn't work:

IF(AND(TODAY()(EDATE(AL7,12)),OR(AN7="Referred to
Tx")),IF(AA7<"","Update
Eval Before Hearing","")),""))

I realize that this is a very long and detailed formula, so I understand
if
it's asking too much............

Happy 4th!

Dan

Sorry, I apparently misread your 2nd "large" paragraph as indicating your
existing formula worked as expected accept for the greater than one year
problem. We should be able to handle the less than six months problem with
another IF function (I think<g). Instead of what I suggested earlier, try
putting this...

IF(TODAY()EDATE(AL7,12),"Update Eval Before
Hearing",IF(TODAY()EDATE(AL7,6),"Confirm AC Follow Through",

in front of the **ORIGINAL** formula you had (that is, after the equal sign
but before the first IF) and put TWO closing parentheses at the end of that
original formula. Now, there is a chance that you will have some
non-essential testing conditions left over inside that original formula (I'm
not 100% sure) as a result of this, but it shouldn't matter... the only
dates it will have to process are those where AL is less than 6 months (any
other condition testing for a larger AL date, if in there, will not
activate).

Rick


"Dan the Man" wrote in message
...
Thanks Rick. That got me closer, but still not 100%. With your suggestion,
the "Update Eval Before Hearing" flag does appear if the date in Cell AL7
is
greater than 12 months, however if I enter a date under 6 months, the flag
"Confirm AC follow Through" still shows up. That flag should only appear
(per
the formula below) if more than 6 months, but less than 12 months has
elapsed. I appreciate your suggestion.

Dan

"Rick Rothstein (MVP - VB)" wrote:

Without studying your formula in any detail, and based solely on your
description of the addition you want and the fact that the existing
formula
works correctly, I would guess that putting this (don't miss the comma at
the end)...

IF(TODAY()EDATE(AL7,12),"Update Eval Before Hearing",

in front of the formula you now have (that is, after the equal sign but
before the first IF) and placing a closing parenthesis at the end of your
existing formula, would do what you want.

Rick



"Dan the Man" wrote in message
...
Hey Guyz!

Since Max and Ron have been so helpful, I'll throw out a more complex
formula. My best friend is a senior software engineer, however since
he's
got
married, he hasn't had a lot of time for my spreadsheet problems. He
created
the spreadsheet for me, but I've been left to my own devices since he's
taken
his wife.

Here is another formula I am working with (which works):

=IF(OR(AA7<"",OR(AND(TODAY()AG7,(AN7="AC
Initiated")))),IF(AND(TODAY()AG7,(AN7="AC
Initiated")),IF(AP7="","Check
AC
Status",IF(AND(TODAY()(EDATE(AP7,6)),OR(AN7="AC Initiated")),"Re-Check
AC
Status","")),IF(AND(TODAY()EDATE(AA7,12),OR(AN7=" Referred to
TX")),IF(AL7="","Eval Before
RF",IF(AND(TODAY()(EDATE(AL7,6)),OR(AN7="Referr ed to Tx")),"Confirm AC
Follow
Through","")),"")),IF(AL7<"",IF(AND(TODAY()EDATE (AL7,6),OR(AN7="Referred
to
Tx")),"Confirm AC Follow Through",""),""))

The following are additional requirements I want to encorporate into
the
above "beast of a formula":

A flag entitled "Update Eval Before Hearing" should appear if more than
a
year elapses (from the date that the evaluation was posted in Row AL).
To
clarify, the "Confirm AC Follow Through" flag appears if more than 6
months ,
but less than 12 months has elapsed (which the above formula does
without
difficulty), and the new "Update Eval Before Hearing", should appear if
more
than 1 year elapses. The addition to the formula also presumes that a
Hearing
date was posted in Row AA.

I tried to integrate the following piece of logic into the above
formula
(to
address the above requirement), but it didn't work:

IF(AND(TODAY()(EDATE(AL7,12)),OR(AN7="Referred to
Tx")),IF(AA7<"","Update
Eval Before Hearing","")),""))

I realize that this is a very long and detailed formula, so I
understand
if
it's asking too much............

Happy 4th!

Dan

I think I read your instructions correctly Rick, but Excel didn't seem to
like the additions you gave me (Excel can be so testy at times, lol). I
separated out your suggestion so you can see it better. I also added the two
additional parenthesis at the end of the entire formula..........Dan

=IF(TODAY()EDATE(AL7,12),"Update Eval Before
Hearing",IF(TODAY()EDATE(AL7,6),"Confirm AC Follow Through")),

IF(OR(AA7<"",OR(AND(TODAY()AG7,(AN7="AC
Initiated")))),IF(AND(TODAY()AG7,(AN7="AC Initiated")),IF(AP7="","Check AC
Status",IF(AND(TODAY()(EDATE(AP7,6)),OR(AN7="AC Initiated")),"Re-Check AC
Status","")),IF(AND(TODAY()EDATE(AA7,12),OR(AN7=" Referred to
TX")),IF(AL7="","Eval Before
RF",IF(AND(TODAY()(EDATE(AL7,6)),OR(AN7="Referr ed to Tx")),"Confirm AC
Follow
Through","")),"")),IF(AL7<"",IF(AND(TODAY()EDATE (AL7,6),OR(AN7="Referred to
Tx")),"Confirm AC Follow Through",""),""))))

"Rick Rothstein (MVP - VB)" wrote:

Sorry, I apparently misread your 2nd "large" paragraph as indicating your
existing formula worked as expected accept for the greater than one year
problem. We should be able to handle the less than six months problem with
another IF function (I think<g). Instead of what I suggested earlier, try
putting this...

IF(TODAY()EDATE(AL7,12),"Update Eval Before
Hearing",IF(TODAY()EDATE(AL7,6),"Confirm AC Follow Through",

in front of the **ORIGINAL** formula you had (that is, after the equal sign
but before the first IF) and put TWO closing parentheses at the end of that
original formula. Now, there is a chance that you will have some
non-essential testing conditions left over inside that original formula (I'm
not 100% sure) as a result of this, but it shouldn't matter... the only
dates it will have to process are those where AL is less than 6 months (any
other condition testing for a larger AL date, if in there, will not
activate).

Rick


"Dan the Man" wrote in message
...
Thanks Rick. That got me closer, but still not 100%. With your suggestion,
the "Update Eval Before Hearing" flag does appear if the date in Cell AL7
is
greater than 12 months, however if I enter a date under 6 months, the flag
"Confirm AC follow Through" still shows up. That flag should only appear
(per
the formula below) if more than 6 months, but less than 12 months has
elapsed. I appreciate your suggestion.

Dan

"Rick Rothstein (MVP - VB)" wrote:

Without studying your formula in any detail, and based solely on your
description of the addition you want and the fact that the existing
formula
works correctly, I would guess that putting this (don't miss the comma at
the end)...

IF(TODAY()EDATE(AL7,12),"Update Eval Before Hearing",

in front of the formula you now have (that is, after the equal sign but
before the first IF) and placing a closing parenthesis at the end of your
existing formula, would do what you want.

Rick



"Dan the Man" wrote in message
...
Hey Guyz!

Since Max and Ron have been so helpful, I'll throw out a more complex
formula. My best friend is a senior software engineer, however since
he's
got
married, he hasn't had a lot of time for my spreadsheet problems. He
created
the spreadsheet for me, but I've been left to my own devices since he's
taken
his wife.

Here is another formula I am working with (which works):

=IF(OR(AA7<"",OR(AND(TODAY()AG7,(AN7="AC
Initiated")))),IF(AND(TODAY()AG7,(AN7="AC
Initiated")),IF(AP7="","Check
AC
Status",IF(AND(TODAY()(EDATE(AP7,6)),OR(AN7="AC Initiated")),"Re-Check
AC
Status","")),IF(AND(TODAY()EDATE(AA7,12),OR(AN7=" Referred to
TX")),IF(AL7="","Eval Before
RF",IF(AND(TODAY()(EDATE(AL7,6)),OR(AN7="Referr ed to Tx")),"Confirm AC
Follow
Through","")),"")),IF(AL7<"",IF(AND(TODAY()EDATE (AL7,6),OR(AN7="Referred
to
Tx")),"Confirm AC Follow Through",""),""))

The following are additional requirements I want to encorporate into
the
above "beast of a formula":

A flag entitled "Update Eval Before Hearing" should appear if more than
a
year elapses (from the date that the evaluation was posted in Row AL).
To
clarify, the "Confirm AC Follow Through" flag appears if more than 6
months ,
but less than 12 months has elapsed (which the above formula does
without
difficulty), and the new "Update Eval Before Hearing", should appear if
more
than 1 year elapses. The addition to the formula also presumes that a
Hearing
date was posted in Row AA.

I tried to integrate the following piece of logic into the above
formula
(to
address the above requirement), but it didn't work:

IF(AND(TODAY()(EDATE(AL7,12)),OR(AN7="Referred to
Tx")),IF(AA7<"","Update
Eval Before Hearing","")),""))

I realize that this is a very long and detailed formula, so I
understand
if
it's asking too much............

Happy 4th!

Dan

See the single inline comment....

"Dan the Man" wrote in message
...
I think I read your instructions correctly Rick, but Excel didn't seem to
like the additions you gave me (Excel can be so testy at times, lol). I
separated out your suggestion so you can see it better. I also added the
two
additional parenthesis at the end of the entire formula..........Dan

=IF(TODAY()EDATE(AL7,12),"Update Eval Before
Hearing",IF(TODAY()EDATE(AL7,6),"Confirm AC Follow Through")),

You added two parentheses to the end of the above that I did not ask for
(the two you added at the end of the original formula below are correct,
those I asked for).

=IF(TODAY()EDATE(AL7,12),"Update Eval Before
Hearing",IF(TODAY()EDATE(AL7,6),"Confirm AC Follow Through",

Remove them and see if that makes a difference.

Rick


IF(OR(AA7<"",OR(AND(TODAY()AG7,(AN7="AC
Initiated")))),IF(AND(TODAY()AG7,(AN7="AC Initiated")),IF(AP7="","Check
AC
Status",IF(AND(TODAY()(EDATE(AP7,6)),OR(AN7="AC Initiated")),"Re-Check AC
Status","")),IF(AND(TODAY()EDATE(AA7,12),OR(AN7=" Referred to
TX")),IF(AL7="","Eval Before
RF",IF(AND(TODAY()(EDATE(AL7,6)),OR(AN7="Referr ed to Tx")),"Confirm AC
Follow
Through","")),"")),IF(AL7<"",IF(AND(TODAY()EDATE (AL7,6),OR(AN7="Referred
to
Tx")),"Confirm AC Follow Through",""),""))))

"Rick Rothstein (MVP - VB)" wrote:

Sorry, I apparently misread your 2nd "large" paragraph as indicating your
existing formula worked as expected accept for the greater than one year
problem. We should be able to handle the less than six months problem
with
another IF function (I think<g). Instead of what I suggested earlier,
try
putting this...

IF(TODAY()EDATE(AL7,12),"Update Eval Before
Hearing",IF(TODAY()EDATE(AL7,6),"Confirm AC Follow Through",

in front of the **ORIGINAL** formula you had (that is, after the equal
sign
but before the first IF) and put TWO closing parentheses at the end of
that
original formula. Now, there is a chance that you will have some
non-essential testing conditions left over inside that original formula
(I'm
not 100% sure) as a result of this, but it shouldn't matter... the only
dates it will have to process are those where AL is less than 6 months
(any
other condition testing for a larger AL date, if in there, will not
activate).

Rick


"Dan the Man" wrote in message
...
Thanks Rick. That got me closer, but still not 100%. With your
suggestion,
the "Update Eval Before Hearing" flag does appear if the date in Cell
AL7
is
greater than 12 months, however if I enter a date under 6 months, the
flag
"Confirm AC follow Through" still shows up. That flag should only
appear
(per
the formula below) if more than 6 months, but less than 12 months has
elapsed. I appreciate your suggestion.

Dan

"Rick Rothstein (MVP - VB)" wrote:

Without studying your formula in any detail, and based solely on your
description of the addition you want and the fact that the existing
formula
works correctly, I would guess that putting this (don't miss the comma
at
the end)...

IF(TODAY()EDATE(AL7,12),"Update Eval Before Hearing",

in front of the formula you now have (that is, after the equal sign
but
before the first IF) and placing a closing parenthesis at the end of
your
existing formula, would do what you want.

Rick



"Dan the Man" wrote in message
...
Hey Guyz!

Since Max and Ron have been so helpful, I'll throw out a more
complex
formula. My best friend is a senior software engineer, however since
he's
got
married, he hasn't had a lot of time for my spreadsheet problems. He
created
the spreadsheet for me, but I've been left to my own devices since
he's
taken
his wife.

Here is another formula I am working with (which works):

=IF(OR(AA7<"",OR(AND(TODAY()AG7,(AN7="AC
Initiated")))),IF(AND(TODAY()AG7,(AN7="AC
Initiated")),IF(AP7="","Check
AC
Status",IF(AND(TODAY()(EDATE(AP7,6)),OR(AN7="AC
Initiated")),"Re-Check
AC
Status","")),IF(AND(TODAY()EDATE(AA7,12),OR(AN7=" Referred to
TX")),IF(AL7="","Eval Before
RF",IF(AND(TODAY()(EDATE(AL7,6)),OR(AN7="Referr ed to Tx")),"Confirm
AC
Follow
Through","")),"")),IF(AL7<"",IF(AND(TODAY()EDATE (AL7,6),OR(AN7="Referred
to
Tx")),"Confirm AC Follow Through",""),""))

The following are additional requirements I want to encorporate into
the
above "beast of a formula":

A flag entitled "Update Eval Before Hearing" should appear if more
than
a
year elapses (from the date that the evaluation was posted in Row
AL).
To
clarify, the "Confirm AC Follow Through" flag appears if more than 6
months ,
but less than 12 months has elapsed (which the above formula does
without
difficulty), and the new "Update Eval Before Hearing", should appear
if
more
than 1 year elapses. The addition to the formula also presumes that
a
Hearing
date was posted in Row AA.

I tried to integrate the following piece of logic into the above
formula
(to
address the above requirement), but it didn't work:

IF(AND(TODAY()(EDATE(AL7,12)),OR(AN7="Referred to
Tx")),IF(AA7<"","Update
Eval Before Hearing","")),""))

I realize that this is a very long and detailed formula, so I
understand
if
it's asking too much............

Happy 4th!

Dan

Dan,

The formula contains five OR functions that contain only one argument and
thus are superfluous. There are also a few instances of unnecessary
parentheses which only add to the complexity. The nested IF structure also
appears to be poorly constructed because condtions get tested more than once
at different nesting levels.

Unnecessary OR function and unnecessary parentheses example:

OR(AND(TODAY()AG7,(AN7="AC Initiated")))

Example of condtion(s) being tested more than once at different nesting
levels. Note how [ Today()AG7 ] and [ AN7="AC Initiated" ] is tested twice:

=IF(OR(AA7<"",OR(AND(TODAY()AG7,(AN7="AC
Initiated")))),IF(AND(TODAY()AG7,(AN7="AC Initiated"))...

The OR function is allowed to have only one argument and will return True if
the arguement is true, but this serves no purpose. The argument by itself
achieves the same.

The following is a simplification that removes unnecessary OR functions and
parentheses. It is NOT an answer to your question:

=IF(OR(AA7<"",AND(TODAY()AG7,AN7="AC
Initiated")),IF(AND(TODAY()AG7,AN7="AC Initiated"),IF(AP7="","Check AC
Status",IF(AND(TODAY()EDATE(AP7,6),AN7="AC Initiated"),"Re-Check AC
Status","")),IF(AND(TODAY()EDATE(AA7,12),AN7="Ref erred to
TX"),IF(AL7="","Eval Before RF",IF(AND(TODAY()EDATE(AL7,6),AN7="Referred to
Tx"),"Confirm AC Follow
Through","")),"")),IF(AL7<"",IF(AND(TODAY()EDATE (AL7,6),AN7="Referred to
Tx"),"Confirm AC Follow Through",""),""))

If Rick is not successful at solving your problem, then I suggest you
describe a theoretical (simplified) worksheet layout that models the actual
but is as simple as you can make it. Also provide example data and describe
what you want to achieve. Alternatively, make the workbook available.

Greg


"Dan the Man" wrote:

Hey Guyz!

Since Max and Ron have been so helpful, I'll throw out a more complex
formula. My best friend is a senior software engineer, however since he's got
married, he hasn't had a lot of time for my spreadsheet problems. He created
the spreadsheet for me, but I've been left to my own devices since he's taken
his wife.

Here is another formula I am working with (which works):

=IF(OR(AA7<"",OR(AND(TODAY()AG7,(AN7="AC
Initiated")))),IF(AND(TODAY()AG7,(AN7="AC Initiated")),IF(AP7="","Check AC
Status",IF(AND(TODAY()(EDATE(AP7,6)),OR(AN7="AC Initiated")),"Re-Check AC
Status","")),IF(AND(TODAY()EDATE(AA7,12),OR(AN7=" Referred to
TX")),IF(AL7="","Eval Before
RF",IF(AND(TODAY()(EDATE(AL7,6)),OR(AN7="Referr ed to Tx")),"Confirm AC
Follow
Through","")),"")),IF(AL7<"",IF(AND(TODAY()EDATE (AL7,6),OR(AN7="Referred to
Tx")),"Confirm AC Follow Through",""),""))

The following are additional requirements I want to encorporate into the
above "beast of a formula":

A flag entitled "Update Eval Before Hearing" should appear if more than a
year elapses (from the date that the evaluation was posted in Row AL). To
clarify, the "Confirm AC Follow Through" flag appears if more than 6 months ,
but less than 12 months has elapsed (which the above formula does without
difficulty), and the new "Update Eval Before Hearing", should appear if more
than 1 year elapses. The addition to the formula also presumes that a Hearing
date was posted in Row AA.

I tried to integrate the following piece of logic into the above formula (to
address the above requirement), but it didn't work:

IF(AND(TODAY()(EDATE(AL7,12)),OR(AN7="Referred to Tx")),IF(AA7<"","Update
Eval Before Hearing","")),""))

I realize that this is a very long and detailed formula, so I understand if
it's asking too much............

Happy 4th!

Dan