Need Help using the function WORKDAY

Hi there,

I'm trying to use the function "WORKDAY" in order to have an end date output, based on a calculation, but when the "number_of_days" value is not a whole number, the formula returns an error. How do I have the formula always round up? Is it possible to mix the formula with the function "ROUND" with 0 digits?

Thank you.

/Lund

Find more posts tagged with

Gantt View

Comments

Brett Evans

This formula should do it...

If(number_of_daysX - Round(number_of_daysX) > 0, Round(number_of_daysX) +1 , Round(number_of_daysX) )