Hi
I'm trying to auto-populate a list of bank holidays that fall within a period. On one worksheet, I have a list of all UK bank holidays from 2016 to 2021. On another worksheet I have a date range that is variable.
I want to auto-populate a list on the second worksheet to show all the bank holidays that fall within that date range. I've tried using an array formula with index, but have been unsuccessful! Does anybody have any ideas?
Thanks in advance
Bookmarks