Say A1 is a cell into which the user should enter a date, but not a date
prior to today's date.

In A1 enter:
=IF(TODAY()<Z1,Z1,TODAY())
Then protect A1 and tell the user to enter dates in Z1. Because A1 is
protected, the user can't change it in any way. If the user screws up the
data in Z1, you get today as a default.

You don't have to be much smarter than a user, even a little bit smarter
will do.
--
Gary''s Student
gsnu200708


"Pietro" wrote:

Hi all,
I have some columns(A,B) in my Excel sheet that don't allow to the users to
insert a date prior to today's date,as i used data validation to achieve
this,but actually users write a date in other columns and paste them in the
columns(A,B) in order to put a date that's prior to today's date,how can i
solve this problem?