Skip to Main Content

Absence Duration Logic

Cecilia-OracleJun 5 2020 — edited Aug 7 2020

Hi expert,

As client requested to exclude weekends (Saturday and Sunday) and public holiday (Calendar event) for all employees regardless their work schedule assigned (some employees might have a Monday off instead of weekends) for certain absence type. I would like to ask if it is possible to write a fast formula for this kind of exclusion?

For example,

Employee with work schedule (Sat - Mon: day-off, Tue - Fri: 8H) has applied absence from 8 Jun 2020 (Monday) to 19 Jun 2020 (Friday), assume that no public holiday in between the selected period, and the duration have to be counted as 10 days.

Thank you.

Best regards,


Post Details
Added on Jun 5 2020