Is the start date and Decemis the end date. In thisĮxample, any date in the year 2017 is valid, so January 1, 2017

Enter the Start Date and End Date for your date range.

We want to limit the entries to dates between specific start and

In the Data drop down, leave the default setting of Between, because.

On the Settings tab of the data validation dialog box, from the.

Click Data Validation (click the upper section of the command).

Select cell C4, and on the Excel Ribbon, click the Data tab.

To ensure that they enter a date in the year 2017, you can applyĭata validation to that cell, and type a start and end date in the rules. This example shows two ways to set those dates.Įnter start and end dates on a worksheet Type Dates in the Rules To ensure that a valid date is entered in cell C4, data validation is used, to set a start date and end date. In cell C4, the employee will enter a starting date

In this example, employees will fill in a Vacation Request Form for Written instructions, and the sample file, are below the video.

Create a rule in a custom formula (Custom option).

Show a drop down list of valid dates (List option).

From the Allow drop down in the data validation settings, the following options will be used:

In this video, three different methods are used to validate dates. Limit the entries for one or more cells in an Excel worksheet. More Data Validation Tutorials Data Validation for Dates - Introduction

Create a drop down list in excel