This article gives formulas to generate list of dates with intervals of Months, Quarters and Years

This article compares 3 techniques to refer to previous row on the basis of time taken by them. This shows that Merge method is the superior method.