Need Help using the function WORKDAY

Lund

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

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) )