Excel® Question

General Real Estate Investing
1

When doing dates in Excel…does anyone know the Excel macro for having the next cell’s date advance without having to type each?

Easy enough for the current year, 2006, but don’t know how to do for following years:

Example:

9/01/07

Then to have 10/1/07, etc…thru to 2009…

I.E.

9/01/07
10/01/07<formula to utilize the info in above cell so this doesn’t
have to be manually input

11/01/07<formula to utilize the info in above cell so this doesn’t
have to be manually input

Thanks,
-Mike

2

here is a quick and easy way to do it… Once you have 2 months entered ie. 8/1/2007, 9/1/2007, select both cells, then put your cursor to the bottom right hand corner of the cell. your arrow will turn into a cross. Left click and drag down, it will do what you are looking for.

3

J,

Thanks for getting back to me on this.

-Mike