How to let the Project Start Date to begin from the date of response, and restrict the Project End Date to start from the Project Start Date and end before the project's deadline?
Assume you have a Project Due-Date Scheduler form where your team members need to select a Project, enter the Start Date and End Date of the project.
-
To keep the Start Date of a project realistic, you want to enable only the future dates starting from the date your team member responds to the form.
-
To ensure that they choose a realistic End Date for the selected project, you can assign the maximum number of days that each project in the dropdown will require and display only the dates starting from the selected Start Date + the maximum number days assigned for the chosen project, ensuring that no member chooses a project End Date that is past its deadline.

When you add the project choices on your form, assign the maximum number of days the project can be worked on as shown.

-
Add 2
Date
fields in your form, one for
Project Start Date
and another for
Project End Date.
-
In the
Properties
of
Project Start Date, select working days under
Allowed Days of Week
(exclude Saturday and Sunday).
Under
Allowed Dates, select
Future Dates
including the date of response.
-
In the Properties of
Project End Date, select working days under
Allowed Days of Week (exclude Saturday and Sunday).
-
Under
Allowed Dates, select Range.
-
Under
Starts From, select
Project Start Date
.
-
Under Ends On, click Additional Options and configure the end date to fall on Project Start Date + the maximum number of days assigned for the chosen project in
Days.
