Introduction This article describes a simple approach to validating dates received as strings (e.g., 2/21/2008).It requires on a few lines of code but will confirm that the date provided as a string is an actual date.Download Excel data validation examples Now, instead of typing your list values in the data validation Source box, you add the name that you just defined, preceded by an Equal (=) sign.
You can follow along, or create your own data validation scenarios.
One of the most common data validation uses is to create a drop-down list.
Check out this video for a quick data validation overview.
“31/9/2010”, “31/09/2010” – September has 30 days only 10.
“31/6/2010”, “31/06/2010” -June has 30 days only 9.