I have a worksheet with several start dates in date format...mm/dd/yy. I want to find the upcoming key anniversary dates (5 years, 10 years, 15 years, 20 years, 25 years, 30 years, 35 years, 40 years, 45 years) of all employees so recognition can be given. I want the actual date to show (mm/dd/yy) so I don't miss recognizing them. I have been able to add the formula for number of years, months and days in one cell. I just need the mm/dd/yy of those key anniversary dates. I will not need the data of those without a key anniversary date.