My problem is with the first year only! Can't figure out how to write this
formula with certain criteria within the first year. Which is: If B16(hire
date)< 90 days then "0" on all curcumstances, AFTER 90 days then If B16(hire
date) is between Jan. 1st - June 30th then "3", If between July 1st - Sept
30th then "2". My problem lies when if you have 90 days completed when the
next year rolls around you have "3". Then it's "3" every year untll your 5th
year, then it's "4", every year after that. Example:
Here's what I have now which works fine untill Jan. 1st which should change
to "3" instead it stays at "2" untill a whole year is completed.
=IF(H4<2.4934,0,IF(DATEDIF(B16,TODAY(),"Y")<5,IF(A ND(DATEDIF(B16,TODAY(),"Y")<1,MONTH(B16)6),2,3),4 ))
Thanks in Advance!