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.
Help Article Resources
Check out the Formula Handbook template!