Phil Smith
Active Member
- Joined
- Aug 13, 2004
- Messages
- 285
- Office Version
- 365
- Platform
- Mobile
Hello everyone.
I would like to request some help for the code for the following problem:
Request a date to be entered in dd/mm/yy format. (Input Box?)
If date does NOT comply with dd/mm/yy format, request date again.
If date is earlier than today, request date again.
If date is on a Monday then Cells(6,2) = date entered
If date is NOT on a Monday then Cells(6,2)= first Monday after date entered
Hope this is fairly simple!
Regards,
Phil
I would like to request some help for the code for the following problem:
Request a date to be entered in dd/mm/yy format. (Input Box?)
If date does NOT comply with dd/mm/yy format, request date again.
If date is earlier than today, request date again.
If date is on a Monday then Cells(6,2) = date entered
If date is NOT on a Monday then Cells(6,2)= first Monday after date entered
Hope this is fairly simple!
Regards,
Phil