Sweedler
Board Regular
- Joined
- Nov 13, 2020
- Messages
- 124
- Office Version
- 2016
- Platform
- Windows
- MacOS
Hello
I have a large document for delivery of goods. In one column I have the agreed upon date for delivery of the finished product. In the columns next to I have calculated dates for several steps that precede the product being ready to deliver. These formulas first calculate the number of days from the end date that a step needs to be completed by and then that answer is removed from the end date to get the date for that step's completion. But the formula only calculates the number of days, and I need it to only count that answer as weekdays. Does anyone know a formula that would take that into consideration.
Thank you
I have a large document for delivery of goods. In one column I have the agreed upon date for delivery of the finished product. In the columns next to I have calculated dates for several steps that precede the product being ready to deliver. These formulas first calculate the number of days from the end date that a step needs to be completed by and then that answer is removed from the end date to get the date for that step's completion. But the formula only calculates the number of days, and I need it to only count that answer as weekdays. Does anyone know a formula that would take that into consideration.
Thank you