Network Day giving negative number for the same day

We have this formula to give us how many days are left for the Purchase order

=-NETWORKDAY([Due Date: PO Ready]1150, TODAY())

But whenever I have today selected I get a negative -1 as Day Remaining

Same happens when I select day after tommorow just gives me 2 as Days remaining

How can I fix this? When the days are more or difference is more then the formula works as intended



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!