RockFish74
New Member
- Joined
- Aug 31, 2017
- Messages
- 19
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!
<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>
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? |