Date in wrong century

I need to extract dates from file names. The naming convention is usually a "letter" followed by the year, month, day, time..... I use a formula that is about as simplistic as my skills allow and it works except the dates all come out as 19xx.
File looks like this Z1501211630.22 the end characters are meaningless.
My formula looks something like this =DATE(MID(H2,2,2),MID(H2,4,2),MID(H2,6,2)) which works just fine for a short date 1/21/15 but I need a long date.
I am getting 1915 instead of 2015.

I'm missing something in my simplicity but what?

https://support.office.com/en-sg/art...b-a32dee59b6e4

If all years you will encounter are in the 2000 or later, try =DATE("20" & MID(H2,2,2),MID(H2,4,2),MID(H2,6,2)).

Otherwise, perhaps you could key off of the date the file was created somehow? Or you could establish a rule, like if the 2 digit year is 50 or less, assume it's in the 21st century, but otherwise assume it's the 20th?

At any rate, you probably should be using more than 2 digits to code for the year in the filename.

=date(mid(h2,2,2)+2000,mid(h2,4,2),mid(h2,6,2))

Originally Posted by eboomer

https://support.office.com/en-sg/art...b-a32dee59b6e4

If all years you will encounter are in the 2000 or later, try =DATE("20" & MID(H2,2,2),MID(H2,4,2),MID(H2,6,2)).

Otherwise, perhaps you could key off of the date the file was created somehow? Or you could establish a rule, like if the 2 digit year is 50 or less, assume it's in the 21st century, but otherwise assume it's the 20th?

At any rate, you probably should be using more than 2 digits to code for the year in the filename.

That would be great if it was my file but it is computer generated in several reports that I download.

I'll give your formula a shot ........thanks