Don't use textboxes for this, use date and time picker controls instead (additional controls..., Microsoft Date and Time Picker Control).
Attaching a version of you workbook would be useful.