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