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

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

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
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.
Solved by I. S. in 25 mins
I tried to convert a value into date but excel gave me a unique string referencing months and years instead.
Solved by V. B. in 19 mins
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))))
Solved by M. H. in 22 mins
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
Solved by X. H. in 19 mins