I have entered dates in Column A, what formula do I use to automaticaly advance the date 10 years in Column B?
Try this: With your start date in cell A1
=DATE(YEAR(A1)+10,MONTH(A1),DAY(A1))
Also, Excel questions are best asked in the Office Software Forum.
