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
To restrict user from entering date beyond the specified dates, we need to follow the below steps:
In this way, we can prevent user from entering any date of their choice.
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.