I'm looking for a formula that will allow me to enter an anniversary date and
have Excel calculate how many vacation days an employee has earned. Example:
If I put a date that is before 1979 in cell A1 than cell A2 will read 35, if
the date in A1 is between 1980 and 1984 than cell A2 will read 30, and so on
until I reach the present year. I would like to able to enter the date as
month, day, year in the same cell put I could just use 1 cell for month and
day and another for the year.