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" <mhayes(a)discussions.microsoft.com> wrote in message news:244CB92CB0514A91B29312700CA6A91D(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: counting Next: Change Header on Multiple Sheets without Changing Other Formatting 