help with formula

[Richard]

=IF(DATEDIF(B16,TODAY(),"Y")<5,3,4). This formula works fine but It's still
not quite what I need. B16 is a hire date. If that hire date is July within
the first year then I need it to show a "2" instead of a 3 or 4. This has me
stumped?! In other words: 5years = 4 days, 1-4 years = 3 days, after July in
the first year = 2 days.

 

[SimonCC]

=IF(DATEDIF(B16,TODAY(),"Y")<5,IF(AND(DATEDIF(B16,TODAY(),"Y")<1,MONTH(B16)>7),2,3),4)
Not sure if you want 2 days for in July or after July, since you mentioned
both. You can adjust the >7 part to >6 if I guessed it wrong.

-Simon