NETWORKDAYS - Multiple Date Selection
 

Generally I use the formula =NETWORKDAYS(K7,L7) to determine the
workday count between dates, but today I have a more complex problem -
I have an original date, then I'm capturing UP TO four date changes.

COLUMNS
col. K - orig date, col. L - date move1, col. M - date move2, col. N -
date move3, col. O - date move4, col. P - arrival date

PROBLEM
If the date does not change, I can use the formula:
=NETWORKDAYS(K7,P7). If the date DOES change, I want to add a formula
that calculates the original date with the last move date (not always
the same as the arrival date).

col.K col.L col.M col.N col.O
col.P
Date Orig | Date Move1 | Date Move2 | Date Move3 | Date Move4 |
Arrival Date
| |
08/18/05 | 08/30/05 | 09/13/05 | | | 09/20/05
08/18/05 | 08/30/05 | 09/13/05 | | | 09/20/05
08/18/05 | 08/30/05 | | | | 08/10/05
09/01/05 | | | | | 09/02/05
07/18/05 | 07/29/05 | 08/12/05 | 08/19/05 | 08/24/05 |
08/29/05
06/25/05 | 07/14/05 | 07/28/05 | 08/15/05 | | 08/16/05

The formulas will be created in col. Q (orig and arrival) and col. R
(orig and last move). Can you assist?

=NETWORKDAYS(K7,IF(COUNT(L7:O7),MAX(L7:O7),P7)


On 4 Oct 2005 09:59:15 -0700, "Annabelle" wrote:

Generally I use the formula =NETWORKDAYS(K7,L7) to determine the
workday count between dates, but today I have a more complex problem -
I have an original date, then I'm capturing UP TO four date changes.

COLUMNS
col. K - orig date, col. L - date move1, col. M - date move2, col. N -
date move3, col. O - date move4, col. P - arrival date

PROBLEM
If the date does not change, I can use the formula:
=NETWORKDAYS(K7,P7). If the date DOES change, I want to add a formula
that calculates the original date with the last move date (not always
the same as the arrival date).

col.K col.L col.M col.N col.O
col.P
Date Orig | Date Move1 | Date Move2 | Date Move3 | Date Move4 |
Arrival Date
| |
08/18/05 | 08/30/05 | 09/13/05 | | | 09/20/05
08/18/05 | 08/30/05 | 09/13/05 | | | 09/20/05
08/18/05 | 08/30/05 | | | | 08/10/05
09/01/05 | | | | | 09/02/05
07/18/05 | 07/29/05 | 08/12/05 | 08/19/05 | 08/24/05 |
08/29/05
06/25/05 | 07/14/05 | 07/28/05 | 08/15/05 | | 08/16/05

The formulas will be created in col. Q (orig and arrival) and col. R
(orig and last move). Can you assist?

I think I'm missing a parenthesis at the end of that formula. Should be

=NETWORKDAYS(K7,IF(COUNT(L7:O7),MAX(L7:O7),P7))


On Tue, 04 Oct 2005 12:54:07 -0500, Myrna Larson
wrote:


=NETWORKDAYS(K7,IF(COUNT(L7:O7),MAX(L7:O7),P7)


On 4 Oct 2005 09:59:15 -0700, "Annabelle" wrote:

Generally I use the formula =NETWORKDAYS(K7,L7) to determine the
workday count between dates, but today I have a more complex problem -
I have an original date, then I'm capturing UP TO four date changes.

COLUMNS
col. K - orig date, col. L - date move1, col. M - date move2, col. N -
date move3, col. O - date move4, col. P - arrival date

PROBLEM
If the date does not change, I can use the formula:
=NETWORKDAYS(K7,P7). If the date DOES change, I want to add a formula
that calculates the original date with the last move date (not always
the same as the arrival date).

col.K col.L col.M col.N col.O
col.P
Date Orig | Date Move1 | Date Move2 | Date Move3 | Date Move4 |
Arrival Date
| |
08/18/05 | 08/30/05 | 09/13/05 | | | 09/20/05
08/18/05 | 08/30/05 | 09/13/05 | | | 09/20/05
08/18/05 | 08/30/05 | | | | 08/10/05
09/01/05 | | | | | 09/02/05
07/18/05 | 07/29/05 | 08/12/05 | 08/19/05 | 08/24/05 |
08/29/05
06/25/05 | 07/14/05 | 07/28/05 | 08/15/05 | | 08/16/05

The formulas will be created in col. Q (orig and arrival) and col. R
(orig and last move). Can you assist?

Worked great! Thanks Myrna