Input date via use of input box with validation

I'm trying to create an input box which will do two things (1) ask the user to enter a date in mm/dd/yyyy format and present an error message if the date is not valid to either retry or cancel and (2) the date entered must be a Friday, any other day of week will ask the user to retry or cancel. Not sure if this is possible with a simple input box. I'm mainly interested in part one of question but part two is only an enhancement. Thanks in advance for any comments.

Try something like this. The user could enter any date format that Excel will recognize as a date. The date is converted to a serial date (numeric value). You can set the date's output format later in the code if you paste it in a cell.

Please Login or Register  to view this content.