Works like a charm! Thanks!
If that works correctly for you (all years are considered to be in the 2000's), then this shorter, single function call formula should also work for you...Works like a charm! Thanks!
Is this the same: =date(2000+left(a1,2),mid(a1,3,2),right(a1,2)) ??