excel - I want a cell to reflect how many vacation hours you get depending on how many years of service

Question

CELL A1
1/3/2006

CELL J1
=YEAR(TODAY())


CELL B1

I want a formula that states if Cell A1 is less than 3 years from CellJ1 input "75", if equal or more than 3 years but less than 10 years input "112", if equal or more than 10 years input 150.

Answer 1

You could try this in B1,

=150-(EDATE(A1, 36)>TODAY())*37-(EDATE(A1, 120)>TODAY())*38