data validation excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data Validation Excel 2007

Data Validation Excel 2007

resolvedResolved · Urgent Priority · Version 2007

Rosina has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

Data Validation Excel 2007

On the Validation Criteria under the Data Validation option, we can choose the Date option in order to define which dates are valid.
e.g. dates from 01/04/2011 to 01/04/2012
How can we choose a specific number of days as a notice period?
e.g. Let's say Someone needs to fill in the form and put the date that he would like his product to go instore. But he needs to do that at least 28 days in advance.
What I would like the form to do is NOT to allow anyone to raise the request for his product to go instore with less than 28 days notice.

The professor in the course said that this is possible.
Could someone help me please?

MAny Thanks
Rosina

RE: Data Validation Excel 2007

put =today() in a cell and put validation on the cell that is the cell with <today's date-28

RE: Data Validation Excel 2007

Apologies but it didnt seem to work. Could you send me the steps in detail?

What I did is:
1) used a random cell and put the Today formula in.
2) then in another cell (the one I want to validate), I clicked Data Validation -> Settings -> Allow: Custom -> in the formula bar I wrote < (sourced the other cell with today formula) -28

But it doesnt work.

Could you please help me?

Many Thanks

RE: Data Validation Excel 2007

Hi,

When you're in data validation - choose Date
Change to Is less than
Choose cell with today's date and then -28

This would ensure that the date typed in is 28 days before today's date

RE: Data Validation Excel 2007

Thank you

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Hide separate columns in Excel 2010

If you want to hide columns not adjacent to each other for example, Columns A, C and E then:-

1) Click on the fist column to be hidden i.e. A

2) Press and hold down the CTRL key

3) While holding the CTRL key, left click on the rest of the columns you want to hide i.e. C and E

4) Right click and choose Hide

View all Excel hints and tips


Server loaded in 0.09 secs.