date list in 1 month increments

[bcamp1973]

I want to enter a date in field A1 and have every field after that
display the date in one month increments. So if A1 is 4/30/2006, then
A2 will be 5/30/2006 etc. I've tried using [=EDATE(A1,1)] as suggested
in Excel Help files, but it's returning #NAME? Not sure what I'm doing
wrong?

 

[SteveG]

You probably need to install the Analysis Toolpak.

On the Tools menu, click Add-Ins. In the Add-Ins available list, select
the Analysis ToolPak box, and then click OK.


HTH

Steve

 

[Dave O]

I agree with SteveG's diagnosis of the Analysis Toolpak. However, I
wonder if you don't need a slightly different solution, and here's why:
when I mocked up your scenario and used EDATE with a start date of
1/30/2006 the result was 2/28/2006. The EDATE result for the following
months was 3/28, 4/28 etc, not producing your desired output of 3/30,
4/30.

Are you *always* trying to produce a date on the 30th of the month, or
is that just an example?

 

[bcamp1973]

perfect! Thanks!

 

[bcamp1973]

Well, here's the deal. I'm guessing (haven't started payments yet) that
my mortgage will probably be due the same date of each month. If it's
due the last day of the month, then i agree this is an issue...however,
i'm totally stumped on how this might be overcome???

 

[SteveG]

To always return the last day of the month use EOMONTH.

=EOMONTH(A1,1)

Cheers,

Steve

 

[bcamp1973]

Thanks again!