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

You can use the ADD function to add days, months or years to a date. The add function can be used with an input date field or a calculated date field.

You can use the ADD function to add days, months or years to a date. The add function can be used with an input date field or a calculated date field.

Add days to a date

Step 1: Add a date question in Google Forms.
Step 2: Click on the Addon icon > Select Formfacade > Select Customize this form > Click on the Proceed button.
In the Formfacade customize interface, click on the ⚙️icon next to the date question.
Step 3: Field settings screen will be displayed. Select the "Answer" tab and write the formula to add days to a date.

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")

Step 4: Write the formula in the Calculate option as shown below.

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")

Write the formula in the Calculate option for a date question as shown below.

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")

Write the formula in the Calculate option for a date question as shown below.
Made with formfacade

Last updated: