Error validating the formula for column dating dont interracial just marriage marry one parenting
To restrict a user to entering only weekdays or weekends, configure a custom validation rule based on the WEEKDAY function.With the argument set to 2, WEEKDAY returns an integer ranging from 1 (Monday) to 7 (Sunday).Check out this video for a quick data validation overview.
Allow only workdays: In many situations, you may want to use today's date as the start date of the allowed date range.To pin down existing entries that do not meet your data validation criteria, use the Circle Invalid Data feature as shown in How to find invalid data in Excel.Surprisingly, none of the inbuilt Excel data validation rules cater for a very typical situation when you need to restrict users to entering only numbers in specific cells.The best thing about using a table is that as you add or remove items from your list, your data validation list will update automatically.Note: The following examples use the Custom option where you write formulas to set your conditions.
Below you will find a few examples of custom validation rules for different data types. All Excel data validation rules, built-in and custom, verify only new data that is typed in a cell after creating the rule.