Network Day giving negative number for the same day

Nishith

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

Paul Newcome

Try this:

=IF([Due Date: PO Ready]@row = TODAY(), 1, IF([Due Date: PO Ready]@row = TODAY(1), 2, NETWORKDAY(TODAY(), [Due Date: PO Ready]@row)))