Hi everyone. Using E02 on XP. I am trying to work some formulas and I have
the general idea what I need to do.

I have a date of birth [DOB] and date of hire [DOH]. I need to calculate
Eligibility to Participate by calculating [Age] and [Service] and then: If
[Age]21 AND [Service]1, name the next occuring 01/01 or 07/01 (with the
year).

In other words, once you attain age 21 and have at least 1 year of service,
you are eligible to enroll on the next occuring January 1 or July 1. The
ultimate question is "What is the Date of Eligibility?" If DOB is 05/01/1960
and DOH is 01/01/2007, they are 21 on 05/01/1981 and they have one year of
service on 01/01/2008, resulting in a Date of Eligiblity of 07/01/2008.

I'm working on it but it looks like I'm using a half dozen fields to
calculate each step. I'm sure it can be nested into one formula.

I would appreciate any help or advice, perhaps where to look for examples of
what I need. Thanks in advance for your time.

--
Bonnie W. Anderson
Cincinnati, OH