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