Multiple date validation in a single cell

S

salbie

I am trying to do a rather complicated validation (I think it i
anyway!)

I want to allow ONLY dates of a particular format to be entered int
the one cell - i.e. YYYY OR mm/YYYY OR dd/mm/YYYY

For example, the same cell can have either one of these format
entered, but MUST match one of them to be accepted.

1970 is OK and is captured in the cell as 1970 (not 1/01/1970)
70 is assumed to mean 1970 on entry

05/1970 is OK, captured in the cell as 05/1970 (not 1/05/1970)
5/70 or May-70 is assumed to mean 05/0970 on entry

05/06/2004 is OK
5/6/04 or 5 June 04 is assumed to mean 05/06/2004 on entry

Anyone
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date in unbound textbox 3
Arranging dates in a single column 5
Date and years calculation 2
How to transfer "text" into "date"? 5
In Excel, is there a way to enter dates in mm/yyyy format? 2
Lookup a particular cell in another excel workbook 1
create a month column from date column 4
Excel Date formats 3

Top