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