Good afternoon,

I'm confused about the NETWORKDAYS formula, as it's not working accurately or I'm using it wrong?

I have coverage start date and end date , where I need to returns the number of working days (excluding the holidays) in the last column as shown below.

=NETWORKDAYS([Coverage Start Date]@row, [Coverage End Date]@row, {Statutory Holiday Range 1})

For example row number 3 is returning with "0" but it should be "1"! on the other hand, the result in row 2 is accurate!! Could you please help me with understanding this glitch?


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!