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!

	Till	Plant	Water	Fertilize	Grow	Harvest	Transport	Wash	Transport
Days →→	0.75	1	0.25	0.5	10	1.75	0.25	0.25	0.75
Using SUM, partial days recognized and includes weekends	4/1/2018	4/2/2018	4/3/2018	4/3/2018	4/13/2018	4/15/2018	4/15/2018	4/15/2018	4/16/2018
Should be…partial days recognized and excludes weekends (manual entries)	4/1/2018	4/2/2018	4/3/2018	4/3/2018	4/17/2018	4/18/2018	4/19/2018	4/19/2018	4/20/2018
Function that recognizes partial days and excludes weekends?

<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> </tbody>

 

[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.