...certain date? I would like to enter a date in a cell into excel. I then want excel to Automatically add 1, 2, 3, 4, 5, etc years to the date I enter. I want that added date to display. For example, if I enter 1/1/2000, I will then want 1/1/2001, or 1/1/2002 and so on to display in a cell somewhere below the entered cell. This is constantly in change. One time I may enter 1/1/2003 and wnat it to add 5 years and therefore display 1/1/2008. Or I may want to enter 2/2/1992 and have 3 years later date appear, 2/2/1995. How do I do it please. I have some VBA, macro, and formulation. But I am not practiced with excel dates, adding, going forward. .Thanks.