Thread: Due dates
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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.