NETWORKDAYS calc with 3 columns of dates

  • Thread starter Thread starter Guest
  • Start date Start date
Adds 0 if both dates are not present.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
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
 
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)
 
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
 
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,

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
 
=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)

Mendz5 said:
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
Click to expand...
are
 
=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)

Mendz5 said:
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
Click to expand...
are
 
Back
Top