In range calculaton for blank to show zero

Closed
Report
-
 RayH -
Hello,

I fill A column the receipt date of requests. In B column PO issued date. In C column I have calucalte no. of days beween A & B using formula = Networkdays(A2,B2) and I found answers. But I have some column either column A or B bank, so it shows in Column C some strange numbers. I want this to show zero. So that I can find watever request received and converted to PO, the average lead time to process.

Kindly someone help to arrive correct formula to get Zero for blank entries in one of the range.

Regards,
Alex



2 replies

Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7
Share Your Sample File Dude........
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
Try this:

=IF(ISBLANK(A2),0,IF(ISBLANK(B2),0,NETWORKDAYS(A2,B2)))
Hi! it's works, but I want the netwroking days to be considered Sun to Thurday instead of Monday to friday.