Would this mean that cell level validation would only become a
problem if someone went back to an old date and tried to edit it
to a value that was outside the validation range?

Yes.

Merjet