Due dates

Firas · Dec 1, 2005

Hi..

I would like to know who of the employees continued 5 years at work relying
on his/her starting date. Thanx.

Eddie O · Dec 1, 2005

Assuming the start date is in cell A1,
=(TODAY()-A1)/365>=5

Will return TRUE when greater than or equal to 5 years, FALSE when less.

Bob Phillips · Dec 1, 2005

=IF(DATE(YEAR(A1)-5,MONTH(A1),Day(A1))<=TODAY(),"Yes","No")

--

HTH

RP
(remove nothere from the email address if mailing direct)