drhorn4908
New Member
- Joined
- Mar 30, 2023
- Messages
- 1
- Office Version
- 2007
- Platform
- Windows
looking to create a formula that returns a date as a value. formula would be based on date order was recieved, remaining hours, hours to complete job= ship date. please advise
Schedule Date Formula.xlsx | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
C | D | E | F | G | H | I | J | K | |||
4 | Date Order Received | Total Weekly Capacity Hours | Total Daily Capacity Hours | Remaining Weekly Capacity Hours | Order Received Job Hours | Ship Date | |||||
5 | |||||||||||
6 | 2/23/2022 | 40 | 8 | 24 | 50 | ? | |||||
7 | |||||||||||
Sheet5 |