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

In range calculaton for blank to show zero
Apple airtag range - Guide
Blank photo facebook ✓ - Facebook Forum
Different dates of "end to end encryption message" on blank chat? ✓ - Network Forum
Excel if range of cells contains specific text then return value ✓ - Excel 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

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.

RayH
Sep 13, 2010 at 03:58 PM

I found this link for you:
http://www.cpearson.com/excel/betternetworkdays.aspx

Similar discussions

encryption message several time in chat

blank white page for website

IF statements with dates and criteria

Excel Macro/Code help: Creating sheet for each name in column of another sheet

Formula to Find&replace blank cells in excel

Similar discussions

Subscribe To Our Newsletter!