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.