Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
Adding 1 month to another date
Does anyone have a formula to automatically calculate 1 month forward from a date in another cell?
I have tried =MONTH(Due1,+1) but this returns #Date expected error. (Due1 is the column and cell i am trying to add the month to.
The above would be perfect but also if there is a genius way of the above calculation only being a working day?
Thank you for anyone who can help and taking the time to assist.