Date Calculation Assistance

[RockFish74]

Hello,

I am trying to calculate completion dates for process steps using the WORKDAY function, however, the WORKDAY function alone does not recognize partial days i.e. 0.25, 0.75, etc. Is anyone able to recommend a function that calculates completion dates for each step in a process? I will manually enter the start date of the first process step. Please see my example below.

Thank You!

[TABLE="width: 647"]
<colgroup><col width="392" style="width: 294pt; mso-width-source: userset; mso-width-alt: 13937;"> <col width="49" style="width: 37pt; mso-width-source: userset; mso-width-alt: 1735;" span="4"> <col width="54" style="width: 41pt; mso-width-source: userset; mso-width-alt: 1934;" span="5"> <tbody>[TR]
[TD="class: xl65, width: 392, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 49, bgcolor: transparent"]Till[/TD]
[TD="class: xl67, width: 49, bgcolor: transparent"]Plant[/TD]
[TD="class: xl67, width: 49, bgcolor: transparent"]Water[/TD]
[TD="class: xl67, width: 49, bgcolor: transparent"]Fertilize[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]Grow[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]Harvest[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]Transport[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]Wash[/TD]
[TD="class: xl68, width: 54, bgcolor: transparent"]Transport[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"]Days →→[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0.75[/TD]
[TD="class: xl71, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl71, bgcolor: transparent, align: right"]0.25[/TD]
[TD="class: xl71, bgcolor: transparent, align: right"]0.5[/TD]
[TD="class: xl71, bgcolor: transparent, align: right"]10[/TD]
[TD="class: xl71, bgcolor: transparent, align: right"]1.75[/TD]
[TD="class: xl71, bgcolor: transparent, align: right"]0.25[/TD]
[TD="class: xl71, bgcolor: transparent, align: right"]0.25[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]0.75[/TD]
[/TR]
[TR]
[TD="class: xl73, bgcolor: transparent"]Using SUM, partial days recognized and includes weekends[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]4/1/2018[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]4/2/2018[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]4/3/2018[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]4/3/2018[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]4/13/2018[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]4/15/2018[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]4/15/2018[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]4/15/2018[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]4/16/2018[/TD]
[/TR]
[TR]
[TD="class: xl73, bgcolor: transparent"]Should be…partial days recognized and excludes weekends (manual entries)[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]4/1/2018[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]4/2/2018[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]4/3/2018[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]4/3/2018[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]4/17/2018[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]4/18/2018[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]4/19/2018[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]4/19/2018[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]4/20/2018[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: transparent"]Function that recognizes partial days and excludes weekends?[/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]

 

[thisoldman]

Try this.

Book1
	A	B	C	D	E	F	G	H	I	J
1	Start	0.75	1	0.25	0.5	10	1.75	0.25	0.25	0.75
2	04/01/2018	4/1	4/2	4/3	4/3	4/17	4/19	4/19	4/19	4/20
Sheet1

Cell Formulas
Range	Formula
B2	=WORKDAY($A2, SUM($B$1:B1))

Enter the formula in B2 and copy to the right.

 

[RockFish74]

Thank you for the help! It appears your formula solves my problem.

 

[thisoldman]

I'm glad to help. Thanks for getting back to us.