Convert Text to Date Format

If Date stored as Text, use DATEVALUE("your cell") to convert the Text to Date.