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?