Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to create a series of dates across a row
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill Series Dates: not letting me change the series from year to m | Excel Discussion (Misc queries) | |||
How do I create a custom fill series for dates? | Excel Discussion (Misc queries) | |||
How do I create a weekly series? | Excel Worksheet Functions | |||
EXCEL, I want to create a series of calendars with dates marked f. | Excel Discussion (Misc queries) | |||
HOW DO I SET UP A SERIES OF DATES IN EXCEL? | Excel Discussion (Misc queries) |