Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MONTH INCREMENT FORMULA | Excel Discussion (Misc queries) | |||
how do i do this - increment month by 1 | Excel Worksheet Functions | |||
Excel formula to increment the month by 2? | New Users to Excel | |||
Excel formula to increment the month by 2? | Excel Worksheet Functions | |||
Increment Month/Year in "mmm-yy" format | Excel Programming |