The easiest way is to convert your data entry to include all the days, then use a pivot table. It would also be better if you added a list of Holidays for all the years covered, named "Holidays".

Try this file, with the macro needed.

Absence Calc.xlsm