Counting number of days across several dates

Hi Everyone,

I'm trying to calculate the number of days between varying dates in one spread sheet, overriding blanks (or N/A) and not counting weekends. I've tried countedif, but it doesn't allow for blanks and still counts weekends.

Here are the cells and dates for example:
A1 N/A
B1 N/A
C1 7/10/2012
D1 7/11/2012
E1 7/15/2012
F1 7/18/2012

Cycle times need to be calculated between A1 and B1, C1 and D1, and E1 and F1, then added together for total number of business days. Am I dreaming up the impossible?

What do you want the formula to return for the cycle time between A1 and B1 in your example, where A1 is N/A?

You can use the following formula if you are able to avoid the N/A and just have blanks.

=NETWORKDAYS(A1,A2)+NETWORKDAYS(A3,A4)+NETWORKDAYS(A5,A6)