Convert text date dd/mm/yy to mm/dd/yy

The number 2000 is added to the result to create a valid year.

This number goes into DATE as the year argument.

The month value is extracted with:

MID retrieves characters 4-5.

The result goes into DATE as the month argument.

Note: the year value 2016 was automatically converted to a number when 2000 was added.

For example, =LEFT(“apple”,3) returns “app”.

For example, =MID(“apple”,2,3) returns “ppl”.

For example, =RIGHT(“apple”,3) returns “ple”.