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

  • Profile Image
    exsfvid
    Asked 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?

  • Profile Image
    Kevin_G
    Answered 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
    grade4pagasa
    Answered 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
    exsfvid
    Answered 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
    Nik_C
    Answered 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
    grade4pagasa
    Answered 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
    Welvin
    Answered 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