How to subtract days, months or years from a date?

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

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

Subtract days from 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 subtract days from a date.

SUBTRACT function

You can subtract days from a date by specifying "days" as the term in the SUBTRACT function.

Syntax:
subtract(number_of_days, "days")

Example usage:
TODAY().subtract(30,"days")
Inputdate.subtract(7,"days")

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

Subtract months from a date

You can subtract months from a date by specifying "months" as the term in the SUBTRACT function.

Syntax:
subtract(number_of_months, "months")

Example usage:
TODAY().subtract(6,"months")
Inputdate.subtract(2,"months")

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

Subtract years from a date

You can subtract years from a date by specifying "years" as the term in the SUBTRACT function.

Syntax:
subtract(number_of_years, "years")

Example usage:
TODAY().subtract(1,"years")
Inputdate.subtract(5,"years")

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

Last updated: