Forum Discussion
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. How do I make the holiday date selection stay the same for each auto filled cell?
2 Replies
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.
- Ohhhh perfect thanks!
