![]()
Excel -- Data Validation -- Validation Criteria Examples
Set or exclude a range of numbers, or specify a minimum or maximum.
- Type values into the Data Validation dialog box, OR
- Refer to cells on the worksheet, OR
- Use formulas to set the values
Set or exclude a range of numbers, or specify a minimum or maximum.
- Type values into the Data Validation dialog box, OR
- Refer to cells on the worksheet, OR
- Use formulas to set the values
See examples here: Data Validation
Set or exclude a range of dates, or specify a minimum or maximum.
In this example, the current date is the Start date, and 7 days from the current date is the End date:
- Type dates into the Data Validation dialog box, OR
- Refer to cells on the worksheet, OR
- Use formulas to set the dates
Set or exclude a range of times, or specify a minimum or maximum.
- Type times into the Data Validation dialog box, OR
- Refer to cells on the worksheet, OR
- Use formulas to set the times
The formula in this example uses the current time as an end time:
=TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()))
Set or exclude a range of lengths, or specify a minimum or maximum.
- Type length into the Data Validation dialog box, OR
- Refer to cells on the worksheet, OR
- Use formulas to set the length