Calculating Number of Days in Breaks from Work that fell in the previous 12 months and 1 year

HI All,

I'm putting together a calculator for work, tracking employment periods and breaks where an employee took unpaid leave. The number of calendar days factors into a calculation for long service leave in NSW, Australia.

Once the start and finish dates of these breaks have been put into a sheet, is there a formula to identify the number of days in these breaks that were within the previous 5 years and 12

For example, if someone took a 20 day break last year in March where 5 days fell within the last 12 months, but 15 days are outside of it. Is there a quick way for that to be calculated?

Those unpaid days are excluded for the purpose of calculating average pay per day/week.