Can someone help me come up with a function to calculate a date 1 month ahead?

melissagxpo

For example, in column A I have the date 1/22/23. Now in column B I want it to automatically calculate 2/22/23. I know how to add 30 days to a date in a formula but since not all months have 30 days I want it to show the exact date in the next month.

KPH

I think this posted twice. This is a duplicate

https://community.smartsheet.com/discussion/114382/can-someone-help-me-come-up-with-a-function-to-calculate-a-date-1-month-ahead#latest