software

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.
Assuming date in A1,
In say, B1: =DATE(YEAR(A1),MONTH(A1) 2,DAY(A1))
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;thirumalairajanquot; gt; wrote in message
...
gt; Dear friends,
gt;
gt; In an excel worksheet, in a cell I am having a day, say for example
gt; 03-May-2005 or 03-05-2005, In another cell
gt; I have to increment only the month by 2 i.e from 03-May-2005 to
gt; 03-July-2005 using a formula.
gt;
gt; What formula should I use?
gt;
gt; thanks,
gt; Thirumalairajan.
gt;
gt;
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)

quot;thirumalairajanquot; gt; wrote in message
...
gt; Dear friends,
gt;
gt; In an excel worksheet, in a cell I am having a day, say for example
gt; 03-May-2005 or 03-05-2005, In another cell
gt; I have to increment only the month by 2 i.e from 03-May-2005 to
gt; 03-July-2005 using a formula.
gt;
gt; What formula should I use?
gt;
gt; thanks,
gt; Thirumalairajan.
gt;
gt;