Hi There is Event date field in the form and I want to auto-calculate Event Close date which 10 business days after Event date. I know, I can do this

  • Profile Image
    Hadassah_Jotform
    Asked on November 12, 2021 at 05:21 PM

    Hi There is Event date field in the form and I want to auto-calculate Event Close date which is 10 business days after Event date. I know, I can do this for dates using formula in conditions. But I am not able to it for business Days. Is there any way I can do this?

  • Profile Image
    Jovanne_A
    Answered on November 12, 2021 at 09:06 PM

    Hi, thank you for contacting support.

    Could you please provide us with more details about your requirements so we can assist you properly?

    Do you mean to exclude weekends and holidays from the calculation?

    Excluding weekends and holidays from the output calculation doesn't appear to be feasible. However, please confirm if we are on the same page so we can try to find a workaround for you.

    We look forward to your response.

  • Profile Image
    Jan Francis 
    Answered on November 12, 2021 at 09:58 PM

    Hi Hadassah_Jotform,

    Hope you are well, You can try the "Date Limits Option".


    You can set limits on your Date Picker Field in the properties section, by going to the limits tab. This might help calculate just the business days.

    1636771690_618f276a2afde_Jotform 3.jpg

    Unchecking a day will disable all of the same days in the calendar. You can uncheck which day of the week you don't want users to select in the date field. To allow only weekdays, uncheck Saturday and Sunday.


    There are also other sets of rules you can set depending on your requirements. Like:

    • Past & Future
    • Disable Custom Dates
    • Disable Date Ranges


    You can see more detailed steps on this link. https://www.jotform.com/help/337-how-to-use-the-date-limits-option/


    I hope this guide helps Hadassah.

    Cheers,