# Thread: Date Calculation Assistance Thanks: 0 Likes: 0

1. ## Date Calculation Assistance

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!

 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?

2. ## Re: Date Calculation Assistance

Try this.
ABCDEFGHIJ
1Start0.7510.250.5101.750.250.250.75
204/01/20184/14/24/34/34/174/194/194/194/20

Sheet1

Worksheet Formulas
CellFormula
B2=WORKDAY(\$A2, SUM(\$B\$1:B1))

Enter the formula in B2 and copy to the right.

3. ## Re: Date Calculation Assistance

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

4. ## Re: Date Calculation Assistance

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