How to exclude weekends when using dynamic date selections?

  • Profile Image
    Asked on December 11, 2020 at 07:15 PM


    I've created a form for work in which students can request a transcript. We advise them that the requests take no less than 3 business days to process. We ask them to tell us their desired date to pick up their transcript. I am using the calendar picker in the form and i have excluded weekends since these are not business days. I learned that i can use Dynamic Date Selections and choose today+x (where x is the number of days to be added to today). This mostly works, except it counts the weekend days. How can i exclude the weekends in this calculation?

    Thanks in advance for your help!


  • Profile Image
    Answered on December 11, 2020 at 11:08 PM

    Hi Mike,

    For the Date field settings, all the days that will result in a working day when 3 working days are added we will use the date field with the following settings.


    Here is how the result will show. The user will only get one day to pick. You can change it based on your requirement.


    Now the most important step is to add a date field and activate the CURRENT DATE option in it. This field will remain hidden and it will be used as the main trigger point for all the conditions.


    Now you'll have to add multiple date fields in order to avoid showing the weekends using conditions. For example, if the day is Wednesday then the 3rd day will be Saturday. But to show the next working day which is Monday you'll have to add +5. You can use this one condition for Wednesday, Thursday, and Friday.

    Here is how you will create the show/hide condition.



    Now for example, if someone is placing the order on a Saturday then you'll need the date to add +4, so you'll need another date field in which you'll use Today+4 for both start and end date. You'll have to add conditions for this as well.

    I've created a clone for you. You can test it and clone it from the link below.

    You can clone it using the guide below.

    Please try it and if you have any questions then please let us know.