Networkdays Help/Issue?
Hi, I have a formula that for networkdays: Here is the Formula.
=IFERROR(NETWORKDAYS(TODAY(), [Due No Later Than]@row, Holidays:Holidays)  1, "NA")
However, anytime the days goes to negative it instantly goes to negative 3 (3). So the calculation shoots from 0 to 3 the when the day shifts even though it should be 1, So all my negative numbers are off by 2. Here is an example.
As you can see, the network days are all correct for the positive values, but immediately once it goes negative it subtracts and additional 2 days. I've confirmed weekends and holidays are not the issue either by testing the formula with different dates. It's just negative values that are the issue.
Anyone know why this is happening?
I can do a workaround fix by using this formula:
=IFERROR(IF((NETWORKDAYS(TODAY(), [Due No Later Than]@row, Holidays:Holidays)  1) >= 0, NETWORKDAYS(TODAY(), [Due No Later Than]@row, Holidays:Holidays)  1, NETWORKDAYS(TODAY(), [Due No Later Than]@row, Holidays:Holidays) + 1), "NA")
But it just seems backwards to have to do this..
Answers

I'm not sure, I would just use the workaround for now. I get a similar answer when I recreate it.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 123 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!