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.
|