Thanks for the suggestions, Tess.
I like your idea of running a validation script. I could color the cell red and maybe trigger a toaster alert in the event of a validation error.
If you could open a feature request too, I would really appreciate that. It would be great to include the "Custom rule" field inside the editable column's Date component.