Validate date so entry can not be greater than today

[imayno]

New to posting...

Thank you to all for the amazing information that has helped me solve too many issues to count!

I am trying to write a custom data validation that validates that the date entered is not less than today's date. However if the date was entered yesterday it can remain as is. Example- today I enter today's date in a cell (a1) and tommorrow I enter a new date in a different cell (a2). Today it validates for today in cell A1, but tomorrow it validates the cell for that date or beyond. It just can't be less than today.

Hope that makes sense.

[vlady]

Welcome to the forum..

Allow: Date
Data: not equal to
Date: =TODAY()

HTH.

[BenMiller]

Just use =A1>=TODAY()

---------- Post added at 07:40 PM ---------- Previous post was at 07:39 PM ----------

Welcome to the forum..

Allow: Date
Data: not equal to
Date: =TODAY()

HTH.

That wouldn't allow anything in the future either ...

[vlady]

reply ok i thought of that didn't read it properly.

don't know if we can attain it though...

and tommorrow I enter a new date in a different cell (a2). Today it validates for today in cell A1, but tomorrow it validates the cell for that date or beyond. It just can't be less than today.

data validation is upon "entering data"
if data exist don't know on "existing values"..

disregard post #2
thanks.

[BenMiller]

don't know if we can attain it though...

I'm not sure if the OP wants to revalidate yesterday's entry, or leave it the way it is since the day it was entered it was fine. The second way is achievable; the first is not (at least not without VBA).

[vlady]

yes vba can do that. but surely not data validation.

It just can't be less than today.

[imayno]

Thanks for the help. I only need to validate at the time of entry (prevent error). After that it needs to remain as orignially inputted.