Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Date Time Functions

 

To generate a series of dates separated by one year

Input the formula: =DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))