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