Calculate business days only

  • scbccned
    Asked on February 9, 2021 at 6:00 PM

    Doing a request for time off form, which includes vacation, medical leave, and personal days off. If someone request Thursday, Friday, Monday, Tuesday, and Wednesday, That totals 5 days of vacation. but when I use a calculation it will show 7 days because of Sat. & Sunday. How can I not include weekends?

  • jherwin
    Replied on February 9, 2021 at 9:23 PM

    There are multiple date picker fields in your form, can you please tell us which date field you are using in the calculation?

    Please mention that label or screenshot the field.

    Looking forward to your response.

  • scbccned
    Replied on February 10, 2021 at 12:26 AM

    1612934769 60236e71722f6 Screenshot (2) Screenshot 10

  • scbccned
    Replied on February 10, 2021 at 12:30 AM

    I need total number of days to be 5. Don't count Saturday and Sunday

    1612934898 60236ef22e355 Screenshot (4) Screenshot 10

  • scbccned
    Replied on February 10, 2021 at 12:32 AM

    1612935160 60236ff80fe66 Screenshot (6) Screenshot 10

  • Vanessa_T
    Replied on February 10, 2021 at 1:39 AM

    Please allow me some time to find a solution to your requirements. Will get back to you here afterwards.

  • Vanessa_T
    Replied on February 10, 2021 at 2:16 AM

    Apologies, unfortunately, due to the wide range of possibilities of the number of days that can be taken for leave, I am having a hard time creating a form/calculation that will work on all scenarios.

    If you are fine with alternatives, how about allowing your users to set the start of their leave date, then specifying how many days they want to take a leave then we will calculate the end date?

    If you are fine with that, you may want to check out my colleague's demo form here:

    https://form.jotformpro.com/52807289886979

    You can replace Due Date with number of leave days.

    For a complete guide, please see my colleague's (abajan) answer here:

    https://www.jotform.com/answers/677930-Can-Weekends-be-Excluded-from-the-Results-of-DateTime-Calculations