Convert string of digits into a date

[Scott Lolmaugh]

I have a date code in the format:
YYMMDDSS
....where "SS" is a sequence number.
I want to extract the day, month, and year data from the string and make a
date that can be used in subsequent date calculations.
Is there a function that would allow me to extract the characters from
position 5 & 6, or 3 & 4, or 1 & 2 that I can then concatonate into a proper
date format?
Thanks,
Scott

[daddylonglegs]

Try

=DATE(LEFT(A1,2),MID(A1,3,2),MID(A1,5,2))