How to Specify Dates using Excel Data Validation?

How to Specify Dates using Excel Data Validation?


Exceed expectations’ information approval highlight is underused in light of the fact that numerous clients don’t understand how adaptable it is, particularly where dates are concerned.

Dates appear to confound things, yet just in your mind! This element handles dates fine. Here are four approaches to express dates utilizing information approval: strict esteems, input esteems, a rundown, and recipes.


I’m utilizing Excel 2016 (work area) on a Windows 10 64-bit framework. You can work with your own information or download the showing .xlsx and .xls documents. Exceed expectations” Table protest isn’t upheld in the menu form, so #3 won’t work in .xls documents.

The program variant backings existing approval controls, however you can’t make them or change them in the program.


To install office setup, click here.


The most effortless way


Utilizing exacting dates is the least complex approach to make an approval control that limits contribution to a scope of dates. You simply enter the first and last adequate dates as takes after:

Select the cell to which you’re including the approval control.

Tap the Data tab.

In the Data Tools gathering, click Data Validation.

In the subsequent exchange, pick Date from the Allow dropdown. Doing as such updates the exchange. The Data control defaults to Between, which is the thing that we need, so don’t change that setting.

In the Start Date control, enter the primary date in the period.

At last Date control, enter the last date in the period (Figure A).

Snap OK.


Click here to get office 2016 product key


Information esteems


Simple is extraordinary, however assume you regularly refresh the limits of your date go? The arrangement is as yet basic, yet it requires two info cells at the sheet level.

Figure C indicates two info cells, C1 and C2, for the begin and end dates, individually. Now, the procedure is nearly the same as #1, aside from that you will allude to the information cells as opposed to entering strict date esteems. To make this approval control, do the accompanying:


Select C4.

Tap the Data tab.

In the Data Tools gathering, click Data Validation.

In the subsequent discourse, pick Date from the Allow dropdown.

Snap inside the Start Date control and enter =C1.

At last Date control, enter =C2 (Figure C).

Snap OK.


This control is as yet easy to execute, yet it gives you the adaptability to change either or the two dates without changing the control’s settings.

It’s important that you could give the information cells names and reference those in stages 5 and 6. For example, you may name C1 StartDate and C2 EndDate. At that point, you’d enter =StartDate and =EndDate in stages 5 and 6, separately.


For more details, visit : Ways to specify dates in excel


Leave a Reply

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