- SAEFSCAsked on September 19, 2017 at 03:33 PM
Is there a way to calculate the number of business days between two dates?
- JotForm SupportMarvihAnswered 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 :)
- SAEFSCAnswered on September 19, 2017 at 04:05 PM
Unfortunately this did not answer my question. By total BUSINESS days, I meant weekdays (Monday-Friday)
- JotForm SupportMarvihAnswered 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.
You can also specify what dates can only be chosen.