How to add days, months or years to a date?

"Set date question that defaults to 1 year from date of submission"- Google Docs Editors Community

Due dates, renewals and follow-ups are all some days, months or years after another date. When people work them out by hand they make mistakes, and Google Forms can't do the calculation for them. With Formfacade, you use the ADD function in the Calculate option of a date question, such as TODAY().add(1,"years") for a membership that runs a year, and your users see the new date as soon as the first date is there. The new date is saved with the response, so your list in Google Sheets is ready to sort.

Create your form and follow the steps below.

Add days to a date

  • On the page that opens, name your form, click Build form and click Proceed.
  • Click on the "Edit" tab.
The tabs Edit, Preview, Share and Responses, with Edit marked
  • Click on the + icon (Add field) in the toolbar on the right.
  • Enter "Input date" as the question and select Date in the question type list
  • Click on the + icon again
  • Enter "Add 5 days to input date" as the question and select Date in the question type list
The toolbar on the right of the Edit tab, with the + icon marked
Click on the ⚙️ icon at the bottom right of the question.
The form in Formfacade, with the EDIT tab, the Add 5 days to input date question and its gear icon marked
Select the "Answer" tab.
The field settings panel with the Answer tab and the Calculate box marked

ADD function

You can add days to a date by specifying "days" as the term in the ADD function.
Syntax:
add(number_of_days, "days")
Example usage:
TODAY().add(30,"days")
Inputdate.add(5,"days")
Note: To enter Inputdate, type @ in the calculate option and select the Input date question from the list.
Write the formula in the Calculate option as shown below. Click Save.
The Calculate box with the Input date field and .add(5,"days")

Add months to a date

You can add months to a date by specifying "months" as the term in the ADD function.
Syntax:
add(number_of_months, "months")
Example usage:
TODAY().add(6,"months")
Inputdate.add(3,"months")
Add another date question the same way, click on the ⚙️ icon and write the formula in the Calculate option as shown below. Click Save.
The Calculate box with the Input date field and .add(3,"months")

Add years to a date

You can add years to a date by specifying "years" as the term in the ADD function.
Syntax:
add(number_of_years, "years")
Example usage:
TODAY().add(1,"years")
Inputdate.add(2,"years")
Add another date question the same way, click on the ⚙️ icon and write the formula in the Calculate option as shown below. Click Save.
The Calculate box with the Input date field and .add(2,"years")
As soon as the user enters the input date, the form shows the new dates.
The Date functions form with an input date of 1 November 2026 and the dates 5 days, 3 months and 2 years after it

Summary

If you need a date that is some days, months or years after another date, Google Forms cannot calculate it. With Formfacade, you can use the ADD function in the Calculate option and the new date will be displayed as soon as the user enters the first date. Create your form and complete the steps above. If you have any questions, write to support.

Last updated: