Get instant live expert help on I need help with excel add years to date

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

I would like to use conditional formatting and icon sets for: Dates between today and 3 years - green tick Dates 60 days before expiry (3 years) - yellow exclamation mark Dates after 3 years - red cross) Please note that Column A has the date the training was done and Column B has a formula which adds 3 years to the date in Column A. I know that I can conditionally format the cells in Column B by using colours only, but I would like to add the icons for a more visual cue.

I tried to convert a value into date but excel gave me a unique string referencing months and years instead.

I'm trying to set an if/or formula. Basically I want it to look at a field, if it contains xx apply the formula to add 10 years to the date in the next field, if the field contains xxx then apply the formula to add 6 years. Below is the formula I've been trying to use. It seems to only recognize the 10 year formula and ignores the second. =IF(OR(J6="xx",J6="xxx"),(DATE((YEAR(K6)+10),MONTH(K6),DAY(K6))),(DATE((YEAR(K6)+6),MONTH(K6),DAY(K6))))

Hi, I am trying to find the time length of service of employees from their intial entry date into categories, "Less than 1 year" " 1 to 3 years" "3 to 5 years" " 5 to 8 years" and " 8 years and above" I currently have managed to find the datedif excel formula for the first column "Less than 1 year" =DATEDIF(I5,TODAY(),"m") <=12 I would like the second formula to bring anyones intial start date to be between 12 months to 36. How would I add that clause to the formula? Thank you