NETWORKDAY function NOT giving me "0" when the two dates that I am comparing are the same.

Options

I am using the formula below and I am not getting the results that I would expect.

=IF([Date Completed]@row = "", "", NETWORKDAY([Original Due Date]@row, [Date Completed]@row))

example 1

[Original Due Date] 03/16/21 and [Date Completed} 03/16/21 I would expect to get back "0" because there is no difference in the dates but it gives me "1"

example 2

[Original Due Date] 08/16/21 and [Date Completed} 08/18/21 I would expect to get back "2" but it gives me "3"

example 3

[Original Due Date] 08/20/21 and [Date Completed} 08/18/21 I would expect to get back "-2" but it gives me "-3"

Is there another function I can use that would give me the results I want?

I know I could add at the end of the formula -1 but that only works if the result is a positive number. I would also have to add an "IF" statement to use +1 if the result is a negative number. If there is no other function to use I could use help with the "IF" statement part.

=IF([Date Completed]@row = "", "", NETWORKDAY([Original Due Date]@row, [Date Completed]@row)this is where I would need the "IF" statement)

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!