Validating entered dates

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

Is there a way either by using Excel functions or VBA, to
validate an entered date i.e 40/12/2003 (dd/mm/yyyy) is
rejected ?

I have tried using Date/Validation, but this seems to fail
when a date is copied in to the cell.

Thanks in advance.

Richard
 
It would appear that is not a date, as there are no months with 40 days. You
can make date range entries
in Data>Validation>Settings tab>Allow>Date.
 
Back
Top