Due dates
 

Hi..

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

Due dates
 

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.

"Firas" wrote:

Hi..

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

Due dates
 

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

--

HTH

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


"Firas" wrote in message
...
Hi..

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