I have been trying to figure out a formula to show how many days a project would take if a start date was given and hours of project assuming a person worked 8 hrs per day. See example below. I used the formula
MIN(D$3-SUM($F$3:G3),8), which will "spread" the "8" until it reaches "0", but when i tried to trigger when a date is reached, =IF(C$3>=J$1,MIN(D$3-SUM($F$3:G3),8),0), it only shows 1 date with an "8" in it. I tried calculating end date using WORKDAYS(C$3,D$3/8) which is 1/15/2020, but couldn't figure out how to stop at end date. Is this possible? Examples of how data should look below.
MIN(D$3-SUM($F$3:G3),8), which will "spread" the "8" until it reaches "0", but when i tried to trigger when a date is reached, =IF(C$3>=J$1,MIN(D$3-SUM($F$3:G3),8),0), it only shows 1 date with an "8" in it. I tried calculating end date using WORKDAYS(C$3,D$3/8) which is 1/15/2020, but couldn't figure out how to stop at end date. Is this possible? Examples of how data should look below.