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

Teams that plan each week often ask for the start and end date of next week on the form. Those dates change every week and people type them in different ways, and Google Forms can't fill them in, so you check them by hand. With Formfacade, you use getDay() to find today's day of the week and ADD to work out next week's start and end dates, so the form opens with them filled in. They update by themselves, so the same form works every week.

Create your form and follow the steps below. The example is a form for next week's goals, with a week that runs from Sunday to Saturday.

Goals & objectives for next week

On the page that opens, name your form, click Build form and click Proceed.
Click on the "Edit" tab.

Click on the + icon (Add field) in the toolbar on the right.
Enter "Week start date" as the question and select Date in the question type list
Click on the + icon again
Enter "Week end date" as the question and select Date in the question type list

Click on the Week start date question, then click on the ⚙️ icon.

Select the "Answer" tab.

Calculate week start date

We can use the getDay() function to determine the day of the week and use the ADD function to calculate the next week start date as shown below.

TODAY().add(7-TODAY().getDay(),"days")

Write the formula in the Calculate option as shown below. Click Save.

Calculate week end date

You can calculate the week end date by adding 6 days to the week start date. We will use the ADD function as detailed below.

week_start_date.add(6, "days")

Note: To enter week_start_date, type @ in the calculate option and select the Week start date question from the list.

Click on the date question for week end date, then click on the ⚙️ icon. Select the "Answer" tab and write the formula to calculate the week end date as shown below. Click Save.

When the form opens, the start and end dates of next week are already filled in. For example, on Monday 2 November the week starts on 8 November and ends on 14 November.

Summary

If you want next week's start and end dates in your form, Google Forms cannot fill them in. With Formfacade, you can use the getDay() and ADD functions in the Calculate option and the dates update by themselves every week. Create your form and complete the steps above. If you have any questions, write to support.