Excel formula to increment the month by 2?

[thirumalairajan]

Dear friends,

In an excel worksheet, in a cell I am having a day, say for example
03-May-2005 or 03-05-2005, In another cell
I have to increment only the month by 2 i.e from 03-May-2005 to
03-July-2005 using a formula.

What formula should I use?

thanks,
Thirumalairajan.

 

[Dong Gaofeng]

maybe you can use the following formula:
=day(a2)&"-"&(month(a2)+2)&"-"&year(a2)

 

[Bob Phillips]

No need to cross-post, you are hitting all the groups. See
http://www.excelguru.ca/XLKBA/XLKBA05.htm to see why it annoys people.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)