steve400243
Active Member
- Joined
- Sep 15, 2016
- Messages
- 429
- Office Version
- 365
- 2016
- Platform
- Windows
Hello, I use this cell formula to calculate network days based on the dates entered in the cells it looks at. In some cases it will return a negative number like -2 or -3, If the number returned is negative Is there a way to have the cell just read 0? Thank you for your help.
VBA Code:
=IF(NETWORKDAYS.INTL(LOOKUP(2,1/($G$3:$G3>0),$G$3:$G3),I3),NETWORKDAYS(LOOKUP(2,1/($G$3:$G3>0),$G$3:$G3),I3,Sheet2!$B$2:$B$7))-1