Validating excel

Rated 4.39/5 based on 622 customer reviews

Using literal dates is the simplest way to create a validation control that limits input to a range of dates.You just enter the first and last acceptable dates as follows: This is the simplest way to designate a range for a data validation control. It's easy to implement and easy to modify—simply select the cell, repeat the above steps, and change one or both dates.Easy is great, but suppose you often update the boundaries of your date range?The solution is still simple, but it requires two input cells at the sheet level.Excel's data validation feature is underused because many users don't realize how versatile it is, especially where dates are concerned.Dates seem to complicate things, but only in your head! Here are four ways to express dates using data validation: literal values, input values, a list, and formulas.In the resulting dialog, check the My Table Has Headers option and then click OK.Because the sheet-level list is a Table object, the control will update as you modify the list.

Or you could accept any date except those that fall on a Wednesday using the formula =WEEKDAY(C4,2)Validation is simple, but it's also flexible—and dates are no problem.Simply click any cell in the list and press Ctrl T.Or click the Insert tab; you'll find the Table option in the Tables group.To do so, select C4 and launch the Data Validation dialog as you've done before.Then, do the following: This formula evaluates the date's year value.

Leave a Reply