Absence entry validation formula to check past dated leaves are on public holiday or weekend

Summary:

We have a qualification plan where an employee is entitled 10 days in a rolling back period.

Employee works Mon-Fri.

1. historical leave applied from 20 june 2022- 27-june 2022 = 6 days
2. Employee applies new leave from 22 june 2023-24 june 2023 = 2 days
3. rolling period would be from 23 june 2022 - 22 june 2023.

23 june 2022 is an inbetween date in point 1.

So we want to know , how many days in the point 1 duration actually falls between 23 june 2022 - 27 june 2022 ?

23 june 2022 - 27 june 2022 = 3 working days ( checking manually in calendar)

This will helps us identify how many entitlements have been used and how many pending.

Thanks,

Content (required):

We have a qualification plan where an employee is entitled 10 days in a rolling back period.