From: mhayes on 21 Apr 2010 16:13 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). From: Mike H on 21 Apr 2010 16:23 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). From: "David Biddulph" groups [at] on 21 Apr 2010 18:11 =20&MID(C7,5,2) & LEFT(C7,2) & MID(C7,3,2) or =19&MID(C7,5,2) & LEFT(C7,2) & MID(C7,3,2) or ... -- David Biddulph "mhayes" wrote in message news:244CB92C-B051-4A91-B293-12700CA6A91D(a)microsoft.com...> 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).  |  Pages: 1 Prev: countingNext: Change Header on Multiple Sheets without Changing Other Formatting