Ok if I change the 400 to 800 the formula works for everyone including people that have been with the company for 10 years or more. 

=IF(DATEDIF(E6,TODAY(),"y")<10,DATEDIF(E6,TODAY(), "m")*3.34,800+DATEDIF(DATE(YEAR(E6)+10,MONTH(E6),DAY(E6)),TODAY(),"m")*6.67)
My question is if I change this to 800 to make the formula work, am I just changing it to "make it work" or is this a logical approach that will work in all scenerio's?

Thanks,
jp