Dynamic Calendar

[dbrhpln]

I've created a dynamic calendar where, based on what year is inputted in AE44 of the Calendar tab, the calendar days are updated as well as highlighted holidays. I now want to add in a formula that pulls in Squad data based on calendar dates, but I am not sure of the formula to use.

 

[dbrhpln]

I've created a dynamic calendar where, based on what year is inputted in AE44 of the Calendar tab, the calendar days are updated as well as highlighted holidays. I now want to add in a formula that pulls in Squad data based on calendar dates, but I am not sure of the formula to use.

Updated image to show name labels of columns of data