Excel formula to increment the month by 2?
 

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.

Excel formula to increment the month by 2?
 

Assuming date in A1,
In say, B1: =DATE(YEAR(A1),MONTH(A1)+2,DAY(A1))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"thirumalairajan" wrote in message
...
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.

Excel formula to increment the month by 2?
 

There are answer in New Users, and in Programming. No need to cross-post.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"thirumalairajan" wrote in message
...
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.