>If in first text box value= oct 2009, i want value in 2nd text sep 2010 where year=1
>
>If in first text box value= oct 2009, i want value in 2nd text sep 2011 where year=2
>
>
>increase 12 month
>
>thanks
Look at GOMONTH() function in help.
textbox2.value = gomonth(textbox1.value,11)
If it's not broken, fix it until it is.
My Blog