Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Date Time Functions

 

Generate a series of dates separated by one month

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