Assuming you DO need formulas, if the starter cell is, say, A2, you can use
the formula =DATE(2005,ROW()-1,1) and copy that down for 47 more cells. This
should be faster to recalculate since it uses only 1 date function (plus
ROW()) instead of 3.

But if you don't need formulas but just want the literal dates, type the
initial date in your starter cell. Then right-click on the fill handle in the
lower right corner of that cell, drag down for 47 cells, and when you release
the mouse button, select Fill Months.

On Mon, 12 Dec 2005 21:00:02 -0800, BorisS <BorisS@discussions.microsoft.com>
wrote:

>I have a starter cell with a month/year. Is there a way other than
>date(year(),month()+1,1) to get the following cell to just add one to the
>month (and I need something that would continue for four years...I know that
>month 13 of any year is the next year, so am figuring that might play into
>this formula).
>
>Thx.