Adding 1 month to another date

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.


Best Answer


Sign In or Register to comment.