Thread
:
dates
View Single Post
#
2
Posted to microsoft.public.excel.newusers
John[_22_]
external usenet poster
Posts: 694
dates
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
Reply With Quote
John[_22_]
View Public Profile
Find all posts by John[_22_]