Help

Using a decimal value for "days" in WORKDAY() formula?

Topic Labels: Formulas
438 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Colm_Hewson
4 - Data Explorer
4 - Data Explorer

Hi all,

Quick one.

I’m trying to build out a timeplanner to estimate when tasks are estimated to finish based on a start date/hour, and an estimated number of hours to complete.

The formula I have so far distills down to days to make it compatible with the workday() function, but the function doesn’t seem to accept anything after the decimal point.

i.e. 1.5 days as an input only increments by 1 day, only the whole integer value is used.

Is there something I’m missing here, or is there another way to configure to correct this behaviour?

Thanks in advance.

0 Replies 0