Convert odd number to date

[Sabosis]

Hello-

I have a report that I ran from our AS400, and the date fields are
coming out strange. I have a string of 109031 that I can cross
reference to see that the "09" is the year, and "031" is the day of
the year. All of the numbers in these fields start with a 1, but it
does not seem to signify anything. 108366 would mean 12/31/2008, etc.
Any ideas on a formula to get these columns to display a regular
calendar date?

 

[JE McGimpsey]

One way:

=DATE(MID(A1,2,2),1,MOD(A1,1000))

 

[JE McGimpsey]

Correction:

=DATE("20"&MID(A1,2,2),1,MOD(A1,1000))