Ya and i have even harder ones from there.

If an employee has not obtained the age on 21 during the year of hire that
employee is eligible to contribute Jan 1 of the year inwhich he/she obtains
the age of 21 (as long as he/she has fulfilled 30 days of service)

If an employee has not obtained the age on 21 during the year of hire that
employee is eligible for the employer match Jan 1 of the year inwhich he/she
obtains the age of 21 (as long as he/she has fulfilled 180 days of service)

~Example A: Joe Smoe DOB 1/1/1989 Hire Date 8/1/2008

Date eligible for deferral = 1/1/2010
Date eligible for match = 1/1/2010

~Example B: Joe Smoe DOB 1/1/1989 Hire Date 8/1/2009

Date eligible for deferral = 1/1/2010
Date eligible for match = 7/1/2010




"Gary''s Student" wrote:

The first one is easy:

=DATE(YEAR(A1+30),MONTH(A1+30)+1,1)


--
Gary''s Student - gsnu200793


"Christy" wrote:

I am looking for a formula that will give me eligibility dates.

An employee is eligible to participate in 401K the 1st of the month
following 30 days of employment.

Hire Date = 1/2/2008 Date needed 3/1/2008

The same employee is eligible for employer match the 1st of Jan or the 1st
of July following 180 days of employment.

Hire Date = 1/2/2008 Date needed 1/1/2009