Hope I get some guidance.
I have a leave request working almost good (after 3 month trying all sort of things).
Employee request a leave (SP List1) --------> Approver receives an email to approve or reject ----------> If approve updates a record holding balances for employees (SP List2) ------> Sends an approved email to employee with
current balance --------> Creates an event in a group calendar. This step is where I have the issue. The calendar does not exclude weekends or holidays.
How can I exclude Weekends and Public holidays (I have created a third list for the public holidays but don't have a clue on what's next).
We have a total of 22 vacation days or pay leave in a year.