This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
In EXCEL I am using the =NETWORKDAYS.INTL formula. When I drag the cell formula to the remaining cells in the row for some reason my holiday cells will not stick and they keep coping, which is making the data incorrect. Does anything know why my holidays will not stick.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
=NETWORKDAYS.INTL(J30,M30,11,$B$260:$B$266)
Or, while in edit mode, select the range B260:B266 and press F4 until four $s appear.
Or visit here:
Hi Sadie,
Have you tried the suggestions provided by Bernie?
May I know the latest progress about this problem?
Best Regards,
Hugo
I did not add a $$. My holidays are in cells B260 through B266 and for some reason whenever I drag the cell it changes the holidays.
=NETWORKDAYS.INTL(J30,M30,11,B260:B266)
Are you using a named range for the holiday date list? Referencing it with $$, like $H$2:$H$20?