Excel formula to increment the month by 2?
as posted in NewUsers
=MIN(DATE(YEAR(A1),MONTH(A1)+{2,3},DAY(A1)*{1,0}))
--
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.
|