Hi
Maybe this : =DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
Change A1 for your needs.
HTH
John
"KRK" wrote in message
...
hello,

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

Thanks

KK