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
