date entry

J

Jarek Kujawa

simpler

=IF(LEN(A1),DATE("20"&RIGHT(A1,2),MID(A1,7,2),MID(A1,FIND
("/",A1)+1,2)),"")
 

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 & month 6
display month only 6
date entry new 3
simple week entry 2
week entry new 3
How to change the year digit? 4
Conditional Format where ANY date is >= 30, 60, 90 days EXCEL 2007 1
Continuous Invoice Nos. 3

Top