software

in excel is there a formula that allows me to increase a date by an exact
number of calendar months? e.g., I want to increase the date of 28-Feb-2006
by 3 calendar months to 28-May-2006

Maybe...

=date(year(a1),month(a1) 3,day(a1))

But this may cause trouble when the dates are near the end of the month (Aug 30
amp; 31 would go to what date?

Sunny wrote:
gt;
gt; in excel is there a formula that allows me to increase a date by an exact
gt; number of calendar months? e.g., I want to increase the date of 28-Feb-2006
gt; by 3 calendar months to 28-May-2006

--

Dave Peterson

Thanks - Just what I was looking for. The problem as you mentioned is minor
(also happens for Feb 29 and leap years!) and when it happens it returns the
next 'real' day.
regards.quot;Dave Petersonquot; wrote:

gt; Maybe...
gt;
gt; =date(year(a1),month(a1) 3,day(a1))
gt;
gt; But this may cause trouble when the dates are near the end of the month (Aug 30
gt; amp; 31 would go to what date?
gt;
gt; Sunny wrote:
gt; gt;
gt; gt; in excel is there a formula that allows me to increase a date by an exact
gt; gt; number of calendar months? e.g., I want to increase the date of 28-Feb-2006
gt; gt; by 3 calendar months to 28-May-2006
gt;
gt; --
gt;
gt; Dave Peterson
gt;