On Tue, 4 May 2010 12:50:44 +0100, "KRK"
wrote:

hello,

How do I add 1 calendar month to a date, regardless of the number of days in
the month?

Thanks

KK

Depends on what you mean.

What is Jan 31 + 1 month? in your specifications?

If the answer is Feb 28, then:

=MIN(DATE(YEAR(A1),MONTH(A1)+1+{1,0},DAY(A1)*{0,1} ))

or

=edate(a1,1)

If the answer is Mar 3, then:

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

--ron