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!

Put your starting date in A1 (say), then in B1 you can put =A1 and
copy this to C1. Then in D1 you can use this formula:

=DATE(YEAR(A1),MONTH(A1)+1,1)

and then just copy this across as far as you need it.

If you need to vary the starting date, just change it in A1 and it
will propagate through.

Hope this helps.

Pete

On Jan 26, 4:08*pm, Equinor wrote:
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!

"Pete_UK" wrote:

Put your starting date in A1 (say), then in B1 you can put =A1 and
copy this to C1. Then in D1 you can use this formula:

=DATE(YEAR(A1),MONTH(A1)+1,1)

and then just copy this across as far as you need it.

If you need to vary the starting date, just change it in A1 and it
will propagate through.

Hope this helps.

Pete

On Jan 26, 4:08 pm, Equinor wrote:
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!

Pete,

It worked like a charm. Thanks!

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!

Glad to hear it - thanks for feeding back.

Pete

On Jan 26, 4:51*pm, Equinor wrote:

It worked like a charm. Thanks