date range setting

August 28, 2010 at 08:08:00
Specs: Windows XP
i want to set the date range between 01-05-1998 to 30-04-2002.when a user tries to enter the date out of this range he should not be allowed.pls help

See More: date range setting

Report •

August 28, 2010 at 10:10:01

Select the cell or cells and use Data Validation
Select 'Date' from the 'Allow:' drop-down list
and enter start and end dates in the two boxes.

Users will only be able to enter dates in that range.


Report •
Related Solutions

Ask Question