Formula for workdays based of category and start date
Hey there. I'm working on building on a sheet for the following:
I need a formula that generates and order date based off of category and start date. (ie If its a "Pool" category, and construction date of "2/1/23", I need a formula that populates an order date that is 10 business days before the construction date.
There will be different categories with different lead times (ie Some will be 20 business days, some 5 business days, etc)
I'm working with IF functions and Workdays but haven't quite been able to put it together. Would love any suggestions you have! Thanks!
Help Article Resources
Check out the Formula Handbook template!