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 facebook page - Facebook Forum
Cannot login to facebook, only get blank page ✓ - Facebook 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
If cell is zero then blank - 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

Excel Macro - Set and autofill a range?

Formula to Find&replace blank cells in excel

My Facebook Page is Loading Blank

blank Facebook white screen

Excel if range of cell contain a text put a cell value in

Similar discussions

Subscribe To Our Newsletter!