How to use Custom Data Validation in Excel

How to use Custom Data Validation in Excel and set up validations like restricting entry to text, specific dates, numerical entries and more.
In this Excel tutorial you will find how to:
==============
1.Prevent the entry of future dates
2. Allow entries dependant on another cell
3. Allow only Text Entries
4. Only text entries with a specified length
5. Allow only upper case letters
6. Allow entry of weekdays only
#ramgopalexcel
This video is created by Ramgopal from Presentation Process in Excel 2016 for Office 365. Visit Presentation-Process.com for more.
*Link to get Microsoft Office 365:*
microsoft.msaf...
Disclosure: The above link is an affiliate link, meaning, at no additional cost to you, I will earn a commission if you click through and make a purchase.