I have a macro which calculates anniversary and other follow up dates from a
given date in a spreadsheet. There is a prompt in the source cell, but users
repeatedly enter the date as a string (3rd Aug 07 instead of 3/8/07). I
would use a formula like T(A1)=€�€�, TRUE,FALSE to check whether the date is in
string or date format but how do I achieve this programmatically before
sending a message box to the user to change the format?

Thanks a lot