Adding partial days that cumulate with workdate

[Swuebb]

Hi, I’m trying to build a spreadsheet that will calculate a schedule date for my business. I’m using workdate to eliminate weekends and holidays but we often have some jobs that are less then a full day. Alls well when the job is a whole number but when inputting fractions of a day my end date won’t move to the next day...for instance start date 3/26/19 add 1 day end date = 3/27/19 but when adding two or more jobs that are less then 1 day using a fraction of a day the formula will not give a cumulative end date. I need to be able to input .25, .50., 75 and whole days to obtain a projected installation date.
Any help will be greatly appreciated.

[Pete_UK]

You could add another term which will add 1 if the fractional part of the days you are adding is greater than zero, i.e. something like:

=your_existing_formula + IF(MOD(fractional_days_to_add,1)>0,1,0)

It's difficult to be more precise, as you haven't given any information about which cells you are using, or the formula that you are using.

Hope this helps.

Pete

[Swuebb]

Pete, thanks for your reply... I’ve used =WORKDAY(L5,I5) L5 is the start date, I5 is the
days where i’m entering either a whole number or a fraction of a day expressed in decimal or fractional form. And the end date is the result of the formula. The end date is then used to calculate the next days end date creating a schedule of weekdays for 30 days os more.
I think I’ll need to use a different formula,one that will allow an accumulation of any fractions of a day. But then not sure how to eliminate weekends and holidays

[Pete_UK]

Try it like this:

=WORKDAY(L5,I5 +(MOD(I5,1)>0) )

Hope this helps.

Pete

[Swuebb]

Pete, that didn’t seem to give me a change in results but I’ve found this formula which allows entry of hours. This might work for us