NETWORKDAYS calc with 3 columns of dates

[Guest]

Bob,

Sorry to be a pest, but what does the zero do?

Mendz

 

[Bob Phillips]

Adds 0 if both dates are not present.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Bob,

Now the boss doesn't want the first day of the range to count. This was the
first formula you gave me with the 3 columns:

=IF(COUNTIF(A1:C1,"<>")=3,NETWORKDAYS(MIN(A1:C1),MAX(A1:C1)),
IF(COUNTIF(A1:C1,"<>")<2,"N/A",
ABS(NETWORKDAYS(IF(A1<>"",A1,B1),IF(OR(A1="",B1=""),C1,B1)))))

I think a "+1" has to be added but I'm not sure where in the formula to
place it.

Thanks,

Mendz

 

[Bob Phillips]

You mean that if there are 3 dates, he wants the difference between the
second and the third?

BTW, this all seems odd, what is it for?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Bob,

No,

If A1 = 7/06/06, B1 = 7/11/06 and C1 = 7/13/06

He wants to begin counting with A1 plus 1 day

If A1 is blank, B1 = 7/11/06 and C1 = 7/13/06

he wants to use B1 + 1 day

If A1 = 7/06/06, B1 is blank and C1 = 7/13/06

He wants to begin counting with A1 plus 1 day

We have a process where project documents are shuffled from one group to
another and he wants to know the duration of time that the documents spend in
each group. Some dates we have, some dates are just not available, that's
why some of the cells can be blank.

Essentially, he has to justify why some projects are being delayed.

Thanks,

Mendz

 

[Guest]

Bob,

Forgot to mention the following:

If A1 and B1 are the same date and C1 is blank, then the result should be 1
day duration.

The same goes if A1, B1 and C1 are the same date the result should be 1 day
duration.

If A1 and C1 are the same date and B1 is blank, the result should be 1 day
duration.

And finally, If B1 and C1 are the same date and A1 is blank the result
should be 1 day duration.

Sorry for this mess :-(

Thank,

Mendz

 

[Guest]

Bob,

Forgot to mention the following:

If A1 and B1 are the same date and C1 is blank, then the result should be 1
day duration.

The same goes if A1, B1 and C1 are the same date the result should be 1 day
duration.

If A1 and C1 are the same date and B1 is blank, the result should be 1 day
duration.

And finally, If B1 and C1 are the same date and A1 is blank the result
should be 1 day duration.

Sorry for this mess :-(

Thank,

Mendz

 

[Bob Phillips]

=IF(COUNTIF(A1:C1,"<>")<2,"N/A",IF(MIN(A1:C1)=MAX(A1:C1),1,NETWORKDAYS(MIN(A
1:C1)+1,MAX(A1:C1))))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

Bob,

Forgot to mention the following:

If A1 and B1 are the same date and C1 is blank, then the result should be 1
day duration.

The same goes if A1, B1 and C1 are the same date the result should be 1 day
duration.

If A1 and C1 are the same date and B1 is blank, the result should be 1 day
duration.

And finally, If B1 and C1 are the same date and A1 is blank the result
should be 1 day duration.

Sorry for this mess :-(

Thank,

Mendz

are

 

[Bob Phillips]

=IF(COUNTIF(A1:C1,"<>")<2,"N/A",IF(MIN(A1:C1)=MAX(A1:C1),1,NETWORKDAYS(MIN(A
1:C1)+1,MAX(A1:C1))))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

Bob,

Forgot to mention the following:

If A1 and B1 are the same date and C1 is blank, then the result should be 1
day duration.

The same goes if A1, B1 and C1 are the same date the result should be 1 day
duration.

If A1 and C1 are the same date and B1 is blank, the result should be 1 day
duration.

And finally, If B1 and C1 are the same date and A1 is blank the result
should be 1 day duration.

Sorry for this mess :-(

Thank,

Mendz

are