ExcelBanter - how can I change MMDDYY to YYYYMMDD?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how can I change MMDDYY to YYYYMMDD? (https://www.excelbanter.com/excel-discussion-misc-queries/262105-how-can-i-change-mmddyy-yyyymmdd.html)

mhayes

how can I change MMDDYY to YYYYMMDD?

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).

Mike H

how can I change MMDDYY to YYYYMMDD?

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).

David Biddulph[_2_]

how can I change MMDDYY to YYYYMMDD?

=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
...
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).

All times are GMT +1. The time now is 06:45 AM.