Date Format

[therealjag]

Hey there,

I'm currently trying to do some error checking on a cell where the user has to enter the exact date format as "dd/mm/yyyy"

I have been using isDate to check if its a date and not text and then using the below function to check the exact format:

Please Login or Register  to view this content.

I've tried the above if statement but doesnt seem to be working for me. Does ayone have any idea's as to why it wont work as it has been driving me potty!

Cheers for any help,

Jag

[Richard Schollar]

Hi Jag

Let me ask why the date format matters - if the user enters a proper Excel date (which you can control eg with Data Validation) the format of the actual entered date shouldn't matter.

Richard

[therealjag]

Hey Richard,

Yeah perhaps I didnt explain fully but the reason I need it in the format dd/mm/yyyy is because I have to import the date into a different system and the import function only recognises dates in the format dd/mm/yyyy only unfortunately.

I've been tinkering around with the statement though and have managed to figure it out....the below statement now seems to do the job:

Please Login or Register  to view this content.