open_in_new
content_copy
=DATEVALUE(CONCATENATE(RIGHT(AL9,4),"-",SUBSTITUTE(SUBSTITUTE(AL9,RIGHT(AL9,5),""),"/","-")))