Need help to adjust automatically my Order Date using Date Formula
I have two date columns in my sheet 1st column is "First Order Date" and the next one is the "Next Order Date" with underlying formula of =[First Order Date]@row+ 30, we need to supply our clients every 30 days.
The problem here is that using that formula "=[First Order Date]@row+ 30" will give you all the day in a week and we don't want it to fall on Saturday and Sunday since we don't have operations every weekend. Now, is there a formula where , when the "=[First Order Date]@row+ 30" falls to Saturday, it will be adjusted to the date of Friday and when it falls to Sunday it will be adjusted to the date of Monday.
Kindly help me to formulate a formula and help me if I need some adjustment to my sheet.
Help Article Resources
Check out the Formula Handbook template!