Show us what's in C7 because I doubt the formula you posted is going to give
the result you expect.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"mhayes" wrote:

The formula =MID(C7,5,2) & LEFT(C7,2) & MID(C7,3,2) gets me to YYMMDD. I
can't figure out how to get the year in full (YYYY).