NETWORKDAYS help with the formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Change A19:A30 to $A$19:$A$30 (just an example of course)
An easy way to do that is to edit the formula, place the cursor in the
address and press F4. Now if you copy the formula, this part will not
adjust.

Another way is to define a name for the table and use that name in your
formulas.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Networkdays (working hours formula now to include holidays) 4
NETWORKDAYS 3
QUESTION REGARDING HOLIDAYS 8
holidays does not work properly in networkdays funtion. 4
Working out a future date with formulas 3
NETWORKDAYS function 1
Formula to check if a date is a holiday 5
vacation excluding holidays 1

Back
Top