Previous Topic Next Topic

In range calculaton for blank to show zero

Closed
alex - Sep 3, 2010 at 01:36 AM
 RayH - Sep 13, 2010 at 03:58 PM
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 responses

Answer 1 / 2
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........
Answer 2 / 2
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:

=IF(ISBLANK(A2),0,IF(ISBLANK(B2),0,NETWORKDAYS(A2,B2)))
alex
Sep 11, 2010 at 02:00 AM
Hi! it's works, but I want the netwroking days to be considered Sun to Thurday instead of Monday to friday.

Similar discussions

How can I make my name text invisible in Discord
imbenmark -
imbenmark -

4 responses
My Facebook Page is Loading Blank
AndreaGwyn -
jonesy -

7 responses
encryption message several time in chat
measking -
HelpiOS -

1 response
Whatsapp web "chat to myself" not working
PeterDays -
Unknown -

31 responses
Lost cellphone,How to restore its message
Gino -
HelpiOS -

1 response