Change the text that SEI NecAccess function outputs used two digit values for the days and months. mm/dd/yyyy instead of m/d/yyyy That would allow that fix formula to be =DATE(MID(C6,3,2),LEFT(C6,2),MID(C6,7,4) Instead of =DATE(MID(C6,FIND("/",C6,FIND("/",C6)+1)+1,4),LEFT(C6,FIND("/",C6)-1),MID(C6,FIND("/",C6)+1,FIND("/",C6,FIND("/",C6)+1)-FIND("/",C6)-1)) because the formula now doesn't have to search for the slash separators in the text.