Need to create a series of dates across a row

[Equinor]

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]

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

 

[Equinor]

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



Pete,

It worked like a charm. Thanks!

 

[David Biddulph]

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.

 

[Pete_UK]

Glad to hear it - thanks for feeding back.

Pete