Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data Validation Excel 2007
|
|
|
The UK's most regular 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Data Validation Excel 2007
Resolved · Urgent Priority · Version 2007
Reply Wed 11 May 2011, 16:03Delegate Rosina said...
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
For upcoming training course dates see: Pricing & availability
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
Reply Thu 12 May 2011, 10:50Delegate Rosina said...
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
Reply Thu 12 May 2011, 14:49Delegate Rosina said...
RE: Data Validation Excel 2007
Thank you
|