You need to change not just the 6, but the pair {7,6}. For n months ahead,
the array should be {n+1,n}, so {14,13} to advance 13 months.

"JNW" wrote:

I found this formula in one of the posts (Credit to Barry Houdini) and I was
wondering how I might edit it.

Right now it calculates the date 6 months from today without passing into
the next month. I need to edit this formula in order to add 10, 11, and 13
months to the date given in another cell. I tried changing the 6 to 13 but
that didn't work.

Any ideas?

Thank you.
JNW