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