How to write a formula to work out due date basing on a reference date

  • Profile Image
    Mavunganidze
    Asked on February 04, 2017 at 08:33 PM

    I want the form to calculate the due date onces and application date is put in one field?

  • Profile Image
    Jim_R
    Answered on February 05, 2017 at 02:52 AM

    Since you never mentioned how you want the calculation / computation to work, I'll just use an example form that computes a due date, 7 days after the selected date on the form.

    Here's the demo form: https://form.jotform.com/70351509403953

    Just pick any date from the DATE FIELD, and the CALCULATED DUE DATE field will automatically add 7 days to it.

    I just used conditions to make it happen. Here's how it was setup:

    If you wish to adjust the due date (e.g. 20 days after) then just change the calculation from +7 to +20 (and so on).

    You may clone my form so you can have a closer look.

    Related guide: How-to-clone-an-existing-form-from-a-URL