I need help!!
I have a rolling schedule where I want to calculate the networkdays, we are now coming up to company close offs and I am trying to add our close off dates by adding the "holiday dates" function
I currently have the holiday dates filled in on another page of the workbook and have entered the formula as "=NETWORKDAYS(B1,E1,'Holiday Dates'!B1:B5)"
When I drag or copy this formula down, I am wanting the B1 & E1 part of the formula to change to B2 & E2 which it does, but I want the holiday date range of "Holiday Dates'!B1:B5)" to stay the same..
Any assistance would be greatly appreciated!
Ben
I have a rolling schedule where I want to calculate the networkdays, we are now coming up to company close offs and I am trying to add our close off dates by adding the "holiday dates" function
I currently have the holiday dates filled in on another page of the workbook and have entered the formula as "=NETWORKDAYS(B1,E1,'Holiday Dates'!B1:B5)"
When I drag or copy this formula down, I am wanting the B1 & E1 part of the formula to change to B2 & E2 which it does, but I want the holiday date range of "Holiday Dates'!B1:B5)" to stay the same..
Any assistance would be greatly appreciated!
Ben