add month to date

O

oomyoo

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

Rowan Drummond

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

Hope this helps
Rowan
 
R

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?
Click to expand...

=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
 
O

oomyoo

Thanks very much!

Ron Rosenfeld said:
=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
Click to expand...
 
Top