One way:

Assuming that 2-digit years <=30 are 21st century and years 30 are
20th century:

=DATE(--(IF(--LEFT(A1,2)<=30,"20","19")&LEFT(A1,2)),1,--MID(A1,4,3))

Note: I assumed that DD could also be DDD for day of the year over 99.

In article ,
Sam wrote:

Hello,

I have a column with dates in the format YY:DD [here DD stands for day of
the year]. Is there a way to have a column that represents the same dates in
the normal MM/dd/YYYY format?
[MM=month#, dd=day# (day of the month), YYYY=year]

Thank you!