title: Converting Timestamp to Date Excel
body: <p>I have a timestamp column that comes in the format "Aug 01 2016 - 13:46". To format it like a date, because I don't need the timestamp, I'm getting rid of the spaces and the timestamp,</p>
  
  <pre><code>(SUBSTITUTE(LEFT(A2,LEN(A2)-8)," ",""))
  </code></pre>
  
  <p>and then doing </p>
  
  <pre><code>DATE(YEAR(RIGHT(C2,4)),MONTH(VLOOKUP(LEFT(C2,3),$H$2:$I$13,2,FALSE)),DAY(IF(ISNUMBER(MID(C2,4,1)),MID(C2,4,2),MID(C2,5,2))))
  </code></pre>
  
  <p>Where I'm grabbing the right 4 digits as the year, doing a vlookup for the month string, and then getting the middle digits for the day (the IF statement is because occasionally the month will be longer than 4 characters). My result is "1/12/05" Cannot figure out what I'm doing wrong, and would so appreciate any help! Would typically use strftime in R, but the dataset is tiny :)</p>
  
  <p>Thanks </p>