 # Get instant live expert help on how to add years to a date in excel “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 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
How do I add determine if date is greater than today in Excel sheet?
Solved by V. J. in 19 mins
I need a formula to calculate duration in years from start date with no current end date.
Solved by D. D. in 23 mins
I have calculated how many y/m/days each employee has worked in our department based on their hire date and today's date. I would like Excel to automatically update the years of service down to y/m/days each time I open Excel.
Solved by Z. Q. in 17 mins
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