Date plus 1 month

[Jim]

Hello,

Thank younin advance for the help. If I have a date of 1/20/2007 and I
would like to keep the format (and the exact day) but simple add a month,
what formula would I use?

a1 1/20/2007
b1 2/20/2007 b1 needs to be 2/20

 

[Don Guillett]

=DATE(YEAR(J7),MONTH(J7)+1,DAY(J7))