Data Validation Accept If ">=Date" Compare Cell Before It

hi all..


i'm looking formula in data validation with criteria ">=date" (without qoute)
input :
1---25/10/2017 (first entry)
2.--24/10/2017 (ignored)
3.--10/10/2017 (ignored)
4.--02/12/2017 (accepted)
etc,....

any help much appreciated,,,

john m

Don't use a formula in validation for that.
Data Validation has a built in Date Comparison function.

so what's formula i use?

You don't use a formula.

Click Data Validation
Choose Allow DATE
Select Greater Than
Enter your date.
Click OK

oooo. i see thank you Jonmo, i miss it
that's not too difficult....

You're welcome.