# Excel DATEVALUE Function

When a Microsoft Excel spread sheet has a column of date data in this format: `Nov 24 1995`

Then the Excel function you’ll find useful is the DATEVALUE function.
This formula here:

`=DATEVALUE((TRIM(MID(R2,5,2))&"-"&TRIM(LEFT(R2,3))&"-"&TRIM(RIGHT(R2,4)))`

Basically grabs the Day, then the Month, then the Year from the column, then converts it to a serial number that Excel recognises as a date. Then format this to display however you want it to.

Written on June 7, 2016