I have used the Networkdyas formula to work out day between to dates
excluding weekends and British bank holidays. the bank holidays are entered
in seperate columns at the end of the sheet. the formula has worked fine in
the orriginal row but as I have tried to copy the formula down through the
workbook the cell references for holiday dates have changed. How can I make
these stay the same whilst the first section of the foruma changes. Any
clues to this would be great thanks!