Network Days count off (as well as showing blank for no entry)
Hello (searched and couldn't find), Thank you in advance for support.
Typical "Start Date" and "Actual End Date" columns. Having an issue with days in between not lining up correctly.
3/16/22 through 3/16/22 should equal "0" however shows "1"
3/16/22 through 3/17/22 shows 1
Every time i try to manipulate the number it doesn't align to one another.
=IFERROR(NETWORKDAYS([Start Date]@row, [Actual End Date]@row) - IF(AND([Start Date]@row <> "", [Start Date]@row = [Actual End Date]@row), -1) - 1, "")
PS: I am also using blanks for no entry in both fields (which works)
Help Article Resources
Check out the Formula Handbook template!