I need the formula for time accrual to auto populate in E4 based on certain criteria.
example:
B4 = hire date
E4= accrual rate
If todays date is equal to or greater than 60 days but less than 1 year from B4 date then E4 = 1
If todays date is equal to or greater than 3 years but less than 4 years from B4 date then E4 = 1.08
If todays date is equal to or greater than 5 years but less than 9 years from B4 date then E4 = 1.5
If todays date is equal to or greater than 10 years but less than 14 years from B4 date then E4 = 1.58
If todays date is equal to or greater than 15 years from B4 date then E4 = 1.92
Solved by A. H. in 18 mins