Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

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

Topic Labels: Formulas
77 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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