How to handle datecodes from excel in R with dplyr : <p>Hy everybody</p>

<p>I already imported a excelsheet with stock data. The import changes the appearance of the date column. This means, imported in R the dataset has structure as seen in dummy_df2:</p>

<pre><code>dates  &lt;- as.tibble(c("32143","32146", "32147","32148"))
Stock1 &lt;- as.tibble(c("NA", "NA", "NA", "NA"))
Stock2 &lt;- as.tibble(c("NA", "NA", "NA", "NA"))
Stock3 &lt;- as.tibble(c("NA", "NA", "NA", "NA"))

dummy_df &lt;- bind_cols(dates,Stock1,Stock2,Stock3)
dummy_df2 &lt;- dummy_df %&gt;% rename(Date ="value", Stock1 = "value1", Stock2 = "value2", Stock3 = "value3")
</code></pre>

<p>I tried convert the Date column variables via the convertToDate command but it seems not to be the right approach. Does anyone know a handy solution to solve this issue?</p>

<p>Kind regards</p>
