add month to date

[Guest]

I'm trying to do a similar thing, but instead of adding a month to show the
month and year, i need to show month/day/year. And another problem is I'm
trying to add a month to the last day of the month.

I tried the date(year(A1),month(A1)+1,day(A1)) but it doesn't seem to work
when adding a month to the last day of the month.

any ideas?

 

[Rowan Drummond]

If you have the analysis toolpak addin installed you can try:
=EDATE(A1,1)

Hope this helps
Rowan

 

[Ron Rosenfeld]

I'm trying to do a similar thing, but instead of adding a month to show the
month and year, i need to show month/day/year. And another problem is I'm
trying to add a month to the last day of the month.

I tried the date(year(A1),month(A1)+1,day(A1)) but it doesn't seem to work
when adding a month to the last day of the month.

any ideas?

=EDATE(A1,1)

The EDATE function is in the Analysis ToolPak. If you get a #NAME error, see
HELP for that function for instructions how to install it.


--ron

 

[Guest]

Thanks very much!

=EDATE(A1,1)

The EDATE function is in the Analysis ToolPak. If you get a #NAME error, see
HELP for that function for instructions how to install it.


--ron