ExcelBanter - NETWORKDAYS

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - NETWORKDAYS (https://www.excelbanter.com/excel-worksheet-functions/114385-networkdays.html)

Trouvera52

NETWORKDAYS

Is there a way to keep the holiday range static while at the same time
allowing the rest of the formula to be copied forward correctly?

Elkar

NETWORKDAYS

Let's say your holiday range is in A1. Refer to it as $A$1 in the formula to
keep it static when copied.

For more info, look up help on Absolute and Relative Cell References.

HTH,
Elkar

"Trouvera52" wrote:

Is there a way to keep the holiday range static while at the same time
allowing the rest of the formula to be copied forward correctly?

Trouvera52

NETWORKDAYS

Thank you ELkar, I'm just getting into Excel -- obviously ;~)

"Elkar" wrote:

Let's say your holiday range is in A1. Refer to it as $A$1 in the formula to
keep it static when copied.

For more info, look up help on Absolute and Relative Cell References.

HTH,
Elkar

"Trouvera52" wrote:

Is there a way to keep the holiday range static while at the same time
allowing the rest of the formula to be copied forward correctly?

All times are GMT +1. The time now is 06:36 AM.