Restrict Dates using Data Validation

How to Restrict Dates using Data Validation in Excel?

If you want to prevent user from entering dates of their choice in specific cells, then this article is for you. In this article we will learn how to restrict user to enter the dates which are preset by the owner of this file.

 

The function used in this tutorial will work on following versions of Microsoft Excel:

Excel 2013, Excel 2010, Excel 2007, Excel 2003

 

Let’s assume the Start Date is 1/1/2014 & End Date is 12/31/2014

 

image 1

 

To restrict user from entering date beyond the specified dates, we need to follow the below steps:

 

  • Select the cells in which data validation needs to be applied.
  • Press ALT + D + L
  • From Settings tab, select Date in Allow dropdown
  • In Start date, enter cell C2 (Start Date)
  • In End date, enter cell C3 (End Date)

image 2

 

  • As we click on OK button; the user will not be allowed to enter any date apart from the specified dates.

 

In this way, we can prevent user from entering any date of their choice.

xlsx-1567

Download-How to Restrict Dates Using Data Validation

Users are saying about us...

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube