Calculation for number of Business Days?

  • SAEFSC
    Asked on September 19, 2017 at 3:33 PM

    Is there a way to calculate the number of business days between two dates?

  • Marvih
    Replied on September 19, 2017 at 3:54 PM

    Yes. I have made an example here https://form.jotformpro.com/72615778412966

    What I did simply putting 2 "Date Picker" fields and 1 "Short Text Entry" field. Then I added a conditional logic that if both "Date" field are filled, I will subtract the value of End Date to Start Date. 

    Calculation for number of Business Days? Image 1 Screenshot 20

    Then pass the total to the "Short Text Entry" which I named "Total working days".

    Hope that helps :)

  • SAEFSC
    Replied on September 19, 2017 at 4:05 PM

    Hi Marvih,

    Unfortunately this did not answer my question. By total BUSINESS days, I meant weekdays (Monday-Friday)

  • Marvih
    Replied on September 19, 2017 at 4:36 PM

    Sorry if I misunderstood. You can disable Saturdays and Sundays so that only Monday-Friday will be totaled.

    Calculation for number of Business Days? Image 1 Screenshot 20

    https://form.jotformpro.com/72615778412966

    You can also specify what dates can only be chosen.