help with formula
 

=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.

help with formula
 

=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


"Richard" wrote:

=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.