How can I calculate the total working hours for a leave period, considering the leave start date, leave end date, and accounting for holidays and weekends in between? The standard working hours per day are 8 hours.

How can I calculate the total working hours for a leave period, considering the leave start date, leave end date, and accounting for holidays and weekends in between? The standard working hours per day are 8 hours.


  1. If you wish to disable weekends from the calendar in your Date field, in the Properties of the Date field, unselect Saturday and Sunday (or the days you don't work) in the Allowed Days of Week dropdown. Do this for both Leave Starts from and Leave Ends on fields.



  2. To disable any local holidays from the calendar of the Date fields, configure a Global Holiday List. Check out the steps to create a Global Holiday List. Once you create a list, associate the holiday list with your form. Check out the steps for associating a global holiday list with your form.
  3. To calculate the number of working hours between 2 dates in the leave application form, add a Formula field from the Advanced Fields to your form and use the AllowedDaysCount function as shown.

    Calculate using Formula field