How use a dynamic range in a formula

Hi all,   I have an Excel calendar for several teams. The columns are the dates. I want to, from a separate sheet, be able to enter a date range and count the days each person has annual leave for ...