add month to date
 

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?

add month to date
 

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

Hope this helps
Rowan

oomyoo wrote:
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?

add month to date
 

On Thu, 1 Dec 2005 15:16:02 -0800, oomyoo
wrote:

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

add month to date
 

Thanks very much!

"Ron Rosenfeld" wrote:

On Thu, 1 Dec 2005 15:16:02 -0800, oomyoo
wrote:

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