dates
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
|