[SOLVED] Autofilling Dates

[Clemson]

Hey everyone,

I'm working on building a spreadsheet to consolidate real estate holdings and give an up-to-the-minute view of the equity in the properties along with a few other items. I would like to automate the spreadsheet as much as possible.

Issue: I'd like to be able to put the purchase date at the top of the spreadsheet with the respective loan data and the dates on the amortization schedule immediately update -- instead of having to update each amortization schedule manually for different investments.

Example:

B8 has the date of purchase

I want the amortization schedule starting in A15 to pull from B8 and the all of the dates following A15 to automatically update in the correct order.



How can I do this?

Thanks,
HD


Edit: Thanks to benishiryo for solving my question. I initially inserted the formula incorrectly.

[RobertMika]

Will the Dates goes day by day?
So
1/2/2013
1/3/2013
.
.

[Clemson]

The dates go month by month - ie. 4/30/13, 5/31/13, etc

[benishiryo]

welcome to the forum, Clemson. if cell B8 is 1 Mar 2013, what do you want to see in A15?
to see 31 Mar 2013
=EOMONTH($B$8,ROWS(A$15:A15)-1)

to see 30 Apr 2013:
=EOMONTH($B$8,ROWS(A$15:A15))

to see 1 Mar 2013 still:
=EDATE($B$8,ROWS(A$15:A15)-1)

copy down the formulas to increase by a month

[Clemson]

Thank you, benishiryo. I can already tell this is a very active, helpful community.

I believe I did not explain what I was looking for to the best of my abilities. I would like to manually enter the closing date (eg 4/30/2013) in B8. The amortization schedule starts at A15 and the first date pulls from B8, and there are 359 cells (for the months - 360 months in 30yr mortgage) following. I would like to automate the date column so that if I change the closing date to, for example, 6/30/2014, A15 automatically updates as well as the 359 months that follow (so that A16 is no longer 5/31/2013, like in the beginning example).

[RobertMika]

Can you attached an example workbook?