Help with Date Calculation

[RockFish74]

Hello,

I am trying to calculate completion dates for process steps. The steps have standard times in days associated with them, however, many of the steps take less than a full day to complete i.e. 0.25, 0.75 days. I tried using the WORKDAY function to calculate the completion date(s), however, WORKDAY does not recognize partial days. Below is an example table that I am trying to build. Can anyone recommend a function that will calculate completion dates based on work days (M-F) only and partial days for the process step durations?

Thank you!


[TABLE="width: 756"]
<colgroup><col width="392" style="width: 294pt; mso-width-source: userset; mso-width-alt: 13937;"> <col width="66" style="width: 49pt; mso-width-source: userset; mso-width-alt: 2332;"> <col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2531;"> <col width="64" style="width: 48pt; mso-width-source: userset; mso-width-alt: 2275;" span="2"> <col width="76" style="width: 57pt; mso-width-source: userset; mso-width-alt: 2702;"> <col width="67" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2389;" span="2"> <col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt: 2417;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2673;"> <tbody>[TR]
[TD="class: xl65, width: 392, bgcolor: transparent"] [/TD]
[TD="class: xl69, width: 66, bgcolor: transparent"]Till[/TD]
[TD="class: xl70, width: 71, bgcolor: transparent"]Plant[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]Water[/TD]
[TD="class: xl70, width: 64, bgcolor: transparent"]Fertilize[/TD]
[TD="class: xl70, width: 76, bgcolor: transparent"]Grow[/TD]
[TD="class: xl70, width: 67, bgcolor: transparent"]Harvest[/TD]
[TD="class: xl70, width: 67, bgcolor: transparent"]Transport[/TD]
[TD="class: xl70, width: 68, bgcolor: transparent"]Wash[/TD]
[TD="class: xl71, width: 75, bgcolor: transparent"]Transport[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Days →→[/TD]
[TD="class: xl72, bgcolor: transparent"]0.75[/TD]
[TD="class: xl73, bgcolor: transparent"]1[/TD]
[TD="class: xl73, bgcolor: transparent"]0.25[/TD]
[TD="class: xl73, bgcolor: transparent"]0.5[/TD]
[TD="class: xl73, bgcolor: transparent"]10[/TD]
[TD="class: xl73, bgcolor: transparent"]1.75[/TD]
[TD="class: xl73, bgcolor: transparent"]0.25[/TD]
[TD="class: xl73, bgcolor: transparent"]0.25[/TD]
[TD="class: xl74, bgcolor: transparent"]0.75[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Using SUM, partial days recognized and includes weekends[/TD]
[TD="class: xl75, bgcolor: transparent"]4/1/2018[/TD]
[TD="class: xl76, bgcolor: transparent"]4/2/2018[/TD]
[TD="class: xl76, bgcolor: transparent"]4/3/2018[/TD]
[TD="class: xl76, bgcolor: transparent"]4/3/2018[/TD]
[TD="class: xl76, bgcolor: transparent"]4/13/2018[/TD]
[TD="class: xl76, bgcolor: transparent"]4/15/2018[/TD]
[TD="class: xl76, bgcolor: transparent"]4/15/2018[/TD]
[TD="class: xl76, bgcolor: transparent"]4/15/2018[/TD]
[TD="class: xl77, bgcolor: transparent"]4/16/2018[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Should be…partial days recognized and excludes weekends (manual entries)[/TD]
[TD="class: xl75, bgcolor: transparent"]4/1/2018[/TD]
[TD="class: xl76, bgcolor: transparent"]4/2/2018[/TD]
[TD="class: xl76, bgcolor: transparent"]4/3/2018[/TD]
[TD="class: xl76, bgcolor: transparent"]4/3/2018[/TD]
[TD="class: xl76, bgcolor: transparent"]4/17/2018[/TD]
[TD="class: xl76, bgcolor: transparent"]4/18/2018[/TD]
[TD="class: xl76, bgcolor: transparent"]4/19/2018[/TD]
[TD="class: xl76, bgcolor: transparent"]4/19/2018[/TD]
[TD="class: xl77, bgcolor: transparent"]4/20/2018[/TD]
[/TR]
[TR]
[TD="class: xl68, 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]

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1055342-date-calculation-assistance.html#post5067455

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it.
Please be patient and do not attempt to post the question again.