Date calculations

Frequently asked questions from our users

Date functions

Formfacade provides built-in date functions that can be used to update today's date, add or subtract dates & more.

Read the full article →

How to automatically pre-fill today’s date in the form?

You can use the TODAY function to update the current date as the answer to a date question in the form.

Read the full article →

How to calculate the days between two dates?

You can subtract the start date from end date to calculate the number of days between the dates.

Read the full article →

How to calculate the age based on date of birth entered by the user?

You can use the DIFF function to calculate the age based on the date of birth entered by the user.

Read the full article →

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.

Read the full article →

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.

Read the full article →

How to calculate the end date based on the start date and term duration selected by the user?

You can use the ADD function to dynamically calculate the end date based on start date and duration selected by the user.

Read the full article →

How to calculate the number of days left in a month?

You can calculate the number of days in the month using DATE function and then subtract the current day of the month to calculate the days remaining in that month.

Read the full article →

How to calculate the day of the week?

You can use the getDay() function to find the day of the week for a specified date.

Read the full article →

How to calculate the start and end date of a work week?

You can use the getDay() function to determine the day of the week for the current date and use the ADD function to calculate the start date and end date for the next week.

Read the full article →

How to add date validations in google forms?

Google Forms does not support response validations for date questions.

Read the full article →

How to validate if the date entered by the user fails within a date range?

Google Forms does not support response validations for date questions.

Read the full article →