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

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?

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.

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.

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,