View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kimdnw
 
Posts: n/a
Default 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?