Forum Discussion
Swatters
Feb 04, 2024Copper Contributor
Autofilling dates without weekends and holidays
While auto filling dates to exclude weekends and holidays, auto filling changes the holiday selection for each cell. If holiday list is A1:A11 for the first cell, the next cell auto fills as A2:A12. ...
HansVogelaar
Feb 04, 2024MVP
Change the reference A1:A11 to $A$1:$A$11.
The $ signs make the reference absolute, i.e. it won't change when you fill down or copy/paste.
- SwattersFeb 04, 2024Copper ContributorOhhhh perfect thanks!