Ship Date formula

[drhorn4908]

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

 

[scoudny]

Hi doc, will this do?
J6 must be formatted as a date obs

=WORKDAY(C6,(H6/E6))

 

[scoudny]

Guess not