Clinton Community College
Home > NIS > Knowledge Base
Information Technology
General Information
Information for Students
Activate Account or Password Reset
Information for Faculty & Staff
You have a spreadsheet where you have a date in column A (A2) and you want Excel to add 5 years to the date placing the results in column B (B2). Enter the following formula in B2 (we will assume you have a heading in B1). Do not worry about the date in A2 is entered as MM/DD/YY. Excel is smart and converts it providing you have the format as a Date. =DATE(YEAR(A2)+5,MONTH(A2),DAY(A2))By the way, you could add # of days or months by modifying this formula.