Microsoft Excel - DATEVALUE Function
=DATEVALUE(cell)
This function can be used to take a text date and convert it into a date value (numeric value). This will only work with acceptable date formats. For custom text to date conversions check out my other video.