Prev: counting
Next: Change Header on Multiple Sheets without Changing Other Formatting
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: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: counting
Next: Change Header on Multiple Sheets without Changing Other Formatting