Related:
- In range calculaton for blank to show zero
- Apple airtag range - Guide
- Blank white square ✓ - Monitor Forum
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
- Excel if range of cells contains specific text then return value ✓ - Excel Forum
- Blank photo facebook ✓ - Facebook Forum
2 responses
Game Start Now
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7
Sep 3, 2010 at 05:40 AM
Sep 3, 2010 at 05:40 AM
Share Your Sample File Dude........
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
26
Sep 3, 2010 at 10:12 AM
Sep 3, 2010 at 10:12 AM
Try this:
=IF(ISBLANK(A2),0,IF(ISBLANK(B2),0,NETWORKDAYS(A2,B2)))
=IF(ISBLANK(A2),0,IF(ISBLANK(B2),0,NETWORKDAYS(A2,B2)))