In range calculaton for blank to show zero

alex - Sep 3, 2010 at 01:36 AM
 RayH - Sep 13, 2010 at 03:58 PM

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.


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
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
Try this:

Hi! it's works, but I want the netwroking days to be considered Sun to Thurday instead of Monday to friday.