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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Formats 1
Date and years calculation 2
Sorting Dates when there are zeros in the month and/or day 2
Excel 2007 displayed dates 2
Excel 2002: How to make the date format uniform ? 1
Convert dates stored as text 2
Date Validation - Excel 2003 5
validate a date range 4

Back
Top