Calculate business days only

  • Profile Image
    scbccned
    Asked on February 09, 2021 at 06: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?

  • Profile Image
    jherwin
    Answered on February 09, 2021 at 09: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.

  • Profile Image
    scbccned
    Answered on February 10, 2021 at 12:26 AM

    1612934769_60236e71722f6_Screenshot (2).

  • Profile Image
    scbccned
    Answered 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).

  • Profile Image
    scbccned
    Answered on February 10, 2021 at 12:32 AM

    1612935160_60236ff80fe66_Screenshot (6).

  • Profile Image
    Vanessa_T
    Answered on February 10, 2021 at 01:39 AM

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

  • Profile Image
    Vanessa_T
    Answered on February 10, 2021 at 02: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