date array shifting

K

kimdnw

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?
 
B

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
 
Top