Calculation for number of Business Days?

  • Profile Image
    SAEFSC
    Asked on September 19, 2017 at 03:33 PM

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

  • Profile Image
    Marvih
    Answered on September 19, 2017 at 03: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. 

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

    Hope that helps :)

  • Profile Image
    SAEFSC
    Answered on September 19, 2017 at 04:05 PM

    Hi Marvih,

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

  • Profile Image
    Marvih
    Answered on September 19, 2017 at 04:36 PM

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

    https://form.jotformpro.com/72615778412966

    You can also specify what dates can only be chosen.