Others

How to Restrict a Date to the Previous 14 Days in Microsoft Forms

Jason Miller Oct 15, 2026 869 views

Question details

The user wants to limit the selectable dates in a Microsoft Forms date question to only the previous 14 days from the time of submission.

How to Restrict a Date to the Previous 14 Days in Microsoft Forms

Product: Microsoft Forms
Device & OS: not provided
Scenario: Creating a form or survey where respondents must select a date that strictly falls within the last two weeks.
Observed behavior: Microsoft Forms currently lacks a built-in validation rule to dynamically restrict date selections to a specific timeframe, such as the previous 14 days.

Before you start

Since Microsoft Forms doesn't have native dynamic date validation, you will need access to Microsoft Excel or Power Automate to implement a post-submission validation workaround.

Solution 1Recommended

Use Excel and Power Automate for Post-Submission Validation

Because Microsoft Forms cannot restrict dates natively before submission, use a connected system like Excel or Power Automate to validate the submitted dates.

Although Microsoft Forms does not offer a direct way to restrict date inputs on the frontend, you can set up a backend workflow that evaluates the dates after submission and flags invalid entries for review.

Link Forms to Excel

Open your Microsoft Form, navigate to the Responses tab, and select 'Open in Excel' to create a linked spreadsheet that automatically syncs new responses.

Create a Date Validation Formula in Excel

In the linked Excel sheet, add a new column for validation. Use a formula like =AND([@Date]>=TODAY()-14, [@Date]<=TODAY()) to flag whether the submitted date falls within the last 14 days.

Set up a Power Automate Flow (Optional)

Create a Power Automate flow triggered by 'When a new response is submitted'. Add a 'Condition' action to check if the difference between the submission date and selected date is less than or equal to 14 days.

Send Notifications for Invalid Dates

Configure the 'If no' branch in Power Automate to automatically send an email to the respondent, informing them of the error and requesting them to resubmit with a valid date.

Use Excel and Power Automate for Post-Submission Validation

Data Accuracy: Using Power Automate ensures you don't have to manually check the dates daily, as the system will automatically handle the validation and notification process.

Solution 2

Submit Feedback for Native Date Restrictions

Vote for this specific feature request in the official Microsoft Feedback Community to encourage developers to add the functionality natively.

Free Microsoft Office alternative

Try WPS Office for Comprehensive Data Management

While Microsoft Forms has specific limitations for frontend date validation, managing and analyzing your collected survey data is often easier with a fully integrated office suite. WPS Office provides a free, lightweight alternative with advanced spreadsheet capabilities to validate, process, and analyze your form data seamlessly.

1. Download WPS Office: Get the free suite from the official WPS Office website and install it on your device.
2. Import Your Form Data: Open your exported form responses effortlessly in WPS Spreadsheet.
3. Apply Advanced Validation: Use WPS Spreadsheet's built-in formulas and conditional formatting to instantly flag dates outside the 14-day window.

Fully compatible with Microsoft Excel (.xlsx) formats for easy form data handling.Advanced formula and data validation tools to effortlessly process and flag submitted dates.Lightweight design ensuring fast installation and smooth performance on any device.Familiar, intuitive user interface for a zero-learning-curve transition.

microsoft office alternative - wps office

Frequently Asked Questions

Can I restrict past dates entirely in Microsoft Forms?

No, Microsoft Forms currently lacks built-in features to dynamically block past dates entirely. You cannot set minimum or maximum date ranges natively on the form interface.

Does Google Forms allow dynamic date restrictions like the previous 14 days?

Google Forms also natively lacks dynamic date range limits out of the box, but unlike Microsoft Forms, it supports third-party add-ons and custom scripts that can enforce specific date constraints before submission.

How do I ensure respondents enter a date in the correct format in MS Forms?

When you add a Date question type in Microsoft Forms, it automatically forces the respondent to use a standard calendar picker interface. This guarantees that the date format submitted will always be valid and standardized.

Office Quick Solutions