What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How to calculate days between two dates including only working days?

    Asked by exsfvid on March 04, 2016 at 12:51 PM

    JotForm team, how it could calculate or count working days (Monday to Friday) between two dates? example date of receipt and date of an activity?

    two dates between two dates
  • Profile Image
    JotForm Support

    Answered by Kevin_G on March 04, 2016 at 03:40 PM

    Unfortunately, I could not find a way to count only working days, currently you can only count the days between two dates without excluding those not working days.

    Here is an example about calculating days: https://form.jotform.com/53097140976967.

    Feel free to clone it.

  • Profile Image

    Answered by grade4pagasa on March 04, 2016 at 10:00 PM

    Hi exsfvid

    TitusN (JotForm Dev Team) just recently released an improved version (on Feb. 23, 2016) of the Dates Difference widget (fig. 1). In the new release, you can manually select specific day(s) of week to exclude in the calculation (in your case, put a check on Saturday & Sunday) - fig. 2

    You can view or clone the demo form I made to see how it works (fig. 3).

    Hope this helps.

    - Randy, fellow JotForm user.

     
    ---------------------------------------------------------------------------------------------------------

    fig. 1

     
    ---------------------------------------------------------------------------------------------------------

    fig. 2

     

    ---------------------------------------------------------------------------------------------------------

    fig. 3

  • Profile Image

    Answered by exsfvid on March 05, 2016 at 09:19 AM

    grade4pagasa

    Thank you very much, the last question, the possibility exists that show your date widget Spanish?

  • Profile Image
    JotForm Support

    Answered by Nik_C on March 05, 2016 at 03:31 PM

    Hello,

    Unfortunately I do not understand your question, could you elaborate more please?

    We'll wait for your response.

    Thank you.

  • Profile Image

    Answered by grade4pagasa on March 05, 2016 at 09:49 PM

    Hi Nik_C.

    exsfvid is asking if you have a way (or widget) to translate the Dates Difference widget (or entire form) into Spanish? Currently the calendar day-labels, widget titles, and output are in American-English.

  • Profile Image
    JotForm Support

    Answered by Welvin on March 06, 2016 at 09:25 AM

    You can translate the label, but not the texts inside the widget. 

    http://www.jotform.com/help/298-How-to-make-your-forms-multilingual