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

encryption message several time in chat
measking -
HelpiOS -

1 response
IF statements with dates and criteria
jimbabama -
Mazzaropi -

3 responses
blank white page for website
yadaves -
ac3mark -

1 response
using web browser page loads but screen blank
inchoate -
leo -

16 responses
using nested if to blank out adjacent cells
WILLYB -
mubashir aziz -

3 responses