-
SAEFSCAsked on September 19, 2017 at 3:33 PM
Is there a way to calculate the number of business days between two dates?
-
MarvihReplied 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.
Then pass the total to the "Short Text Entry" which I named "Total working days".
Hope that helps :) -
SAEFSCReplied 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)
-
MarvihReplied 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.
https://form.jotformpro.com/72615778412966
You can also specify what dates can only be chosen.