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!
Answers
-
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), ""))),"")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!