Originally Posted by joeu2004[_2_]

"Ron Rosenfeld" wrote:
On the other hand, if the 2-digit year should be
interpreted as any other 2-digit year being entered
with the current default settings for Windows of being
interpreted as being 1930-2029, then one could modify
my text import method to use the formula:
=--(RIGHT(A1,3)&" 1,
"&LEFT(A1,FIND("-",A1)-1)+2000-100*(--LEFT(A1,FIND("-",A1)-1)29))

And what is the benefit of that over either of my previous suggestions, to
wit:

For text date:
=--(MID(A1,1+FIND("-",A1),99) & " 1, " & LEFT(A1,2))

For numeric date:
=--(MONTH(A1) & "/1/" & DAY(A1))

Besides being shorter, my suggestions are not limited to the default
interpretation of yy<30, which can be altered in the Regional and Language
Options control panel.

My text formula does make the assumption that the year is always 2 digits,
but the month might not always be 3 characters.

You make the opposite assumptions (more likely). Eliminating both
assumptions, I would write:

=--(MID(A1,1+FIND("-",A1),99) & " 1, " & LEFT(A1,FIND("-",A1)-1))

Still simpler and more flexible, IMHO.

No matter. My only previous point was: you introduced the assumption of
years =2000. I merely offered a simpler implementation of __your__
assumption.