Absence Leaves should include Holidays and exclude Week offs in Absence Duration

Summary

There is a requirement to include Holidays and exclude Week offs while applying Absence Leaves

Content

On applying absence leaves, Holidays should be included in absence duration calculation and Week offs (Saturday and Sunday) should be excluded in absence duration calculation, i.e., on applying Absences, Week off should not be taken up while Holidays should be included just like working days.

Please provide some suggestion how this can be achieved or some custom fast formula that fulfills this requirement.

Version

20D