View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Sue
 
Posts: n/a
Default If statements and Dates

Hello,
I need to flag milestone yrs of service for our employees.

I was able to download the hiredates from my crappy system but the date
appears as mm/dd/yyyy. What formula can I use to flag those who have or
will have completed their 10th, 15th, 20th, 25th, 30th (etc...) year of
service between Sept 2005 and Aug 2006.

Your assistance is greatly appreciated.

Thank you
Sus