date array shifting
 

In my worksheet I have the formula:
=MAX((NETWORKDAYS(C3,H3, A44:A64)-1)*8+(MOD(H3,1)-MOD(C3,1))*24,0)

(thanks to Bob Phillips for the basics and Sloth for the =MAX(formula,0) to
avoid negative number displays)

So for the portion of the formula (NETWORKDAYS(Start date, Finish date,
Holidays)-1), is there a way to keep the holiday range from shifting as I
copy the formula down the page?

date array shifting
 

Hi!

Make that range absolute:

=MAX((NETWORKDAYS(C3,H3, A$44:A$64)-1)*8+(MOD(H3,1)-MOD(C3,1))*24,0)

Biff

"kimdnw" wrote in message
...
In my worksheet I have the formula:
=MAX((NETWORKDAYS(C3,H3, A44:A64)-1)*8+(MOD(H3,1)-MOD(C3,1))*24,0)

(thanks to Bob Phillips for the basics and Sloth for the =MAX(formula,0)
to
avoid negative number displays)

So for the portion of the formula (NETWORKDAYS(Start date, Finish date,
Holidays)-1), is there a way to keep the holiday range from shifting as I
copy the formula down the page?

date array shifting
 

Thanks, Biff!

Kim

"Biff" wrote:

Hi!

Make that range absolute:

=MAX((NETWORKDAYS(C3,H3, A$44:A$64)-1)*8+(MOD(H3,1)-MOD(C3,1))*24,0)

Biff