Date Function to limit cell to receive only a date

[dinosaur1993]

Say for instance, the default date in cell A1 of the active worksheet is today's date. When asking the user for a new date, do anyone know how to check whether or not the value entered is a valid date. (preferrably user can enter any date format). <--- How do I put this in a loop, as long as the value entered is not in a proper date format or is not a date, then it will keep on looping and showing an error message.

Thank you!!

Kind Regards,
dinosaur1993

[jeffreybrown]

You can use data validation...

Data Validation

• Data >> Data Tools >> Data Validation
• Allow: Whole Number
• Data: greater than
• Minimum: 0

[Pete_UK]

Here's an extract from a macro that I put together for another poster (in 2006 !!):

Please Login or Register  to view this content.

It seemed to work okay then ...

Hope this helps.

Pete

[dinosaur1993]

Thanks for the help guys!