date array shifting

[Guest]

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?

 

[Biff]

Hi!

Make that range absolute:

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

Biff

 

[Guest]

Thanks, Biff!

Kim