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


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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!