date list in 1 month increments
 

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?


--
bcamp1973
------------------------------------------------------------------------
bcamp1973's Profile: http://www.excelforum.com/member.php...o&userid=32268
View this thread: http://www.excelforum.com/showthread...hreadid=520200

date list in 1 month increments
 

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


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=520200

date list in 1 month increments
 

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?

date list in 1 month increments
 

perfect! Thanks!


--
bcamp1973
------------------------------------------------------------------------
bcamp1973's Profile: http://www.excelforum.com/member.php...o&userid=32268
View this thread: http://www.excelforum.com/showthread...hreadid=520200

date list in 1 month increments
 

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???


--
bcamp1973
------------------------------------------------------------------------
bcamp1973's Profile: http://www.excelforum.com/member.php...o&userid=32268
View this thread: http://www.excelforum.com/showthread...hreadid=520200

date list in 1 month increments
 

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

=EOMONTH(A1,1)

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=520200

date list in 1 month increments
 

Thanks again!


--
bcamp1973
------------------------------------------------------------------------
bcamp1973's Profile: http://www.excelforum.com/member.php...o&userid=32268
View this thread: http://www.excelforum.com/showthread...hreadid=520200