Formula for workdays based of category and start date

babasmith

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!

Hollie Green

The below should work.

=Iferror(IF([Item Category]@row = "Pool", WORKDAY([Construction Start Date]@row, -20), IF([Item Category]@row = "Appliances", WORKDAY([Construction Start Date]@row, -10), IF([Item Category]@row = "Accessories", WORKDAY([Construction Start Date]@row, -5), ""))),"")