If you put your 3/1/09 in A1, B1, and C1, then in D1 put the formula
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)) and copy that across to the right.
--
David Biddulph

"Equinor" wrote in message
...
Hi folks. I am creating amortization tables in Excel 2007 and I need to
figure out how to create a date series across a row. I need to set it up
so
that the same date appears in three consecutive cells across the row (1
column each for interest, principal and remaining balance) followed by the
next month in the following 3 cells, etc. So, for example: 3/1/2009,
3/1/2009, 3/1/2009, 4/1/2009, 4/1/2009, 4/1/2009, etc.

I hope I am being clear enough.

Thanks in advance for your help!