Using '=MIN(DATE(YEAR(A1),MONTH(A1)+{7,6},DAY(A1)*{0,1}) )'
The alternative, =DATE(YEAR($D$2),MONTH($D$2)+1+C9,0), doesn't retain the day
of the start date. The final argument to the date function is the day; A
day of 0 will result in the last day of the prior month, which is why you'd
have to add 1+C9 months. So if you just need any date in the month that's
six months ahead, this would work fine. If you want the date six months
ahead, the other is more exact.
--Bruce
"JNW" wrote:
Thank you Bob and bpeltzer. I searched some more and found the following and
was wondering if there are any fundamental differences? Just curiousity on
my part because what you have posted works great.
=DATE(YEAR($D$2),MONTH($D$2)+1+C9,0)
"bpeltzer" wrote:
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
|