well it is not clear from your example, which is why you may not have a reply yet. If everyday in the year appears you can just sum the column selecting the previous 365 rows and as you copy the formula down it adjusts


or look at sumproduct((range of dates<=today())*(range of dates>today()-365)*(range of holidays))

so perhaps

=sumproduct((a1:a1000<=today())*(a1:a1000>today()-365)*(b1:b1000))


Regards

Dav