You don’t need to use lubridate for this, the base function as.Date handles this type of conversion nicely. The trick is that you have to provide the origin, which in Excel is December 30, 1899. as.Date(42705, origin = “1899-12-30”) # [1] “2016-12-01” If you want to preserve your column types, you can try using the … Read more
The easiest way is to use lubridate: library(lubridate) prods.all$Date2 <- mdy(prods.all$Date2) This function automatically returns objects of class POSIXct and will work with either factors or characters.
Before converting year-week to a date you have to specify a day of the week but more importantly you have to ensure which of the different conventions is being used. Base R’s strptime() function knows 3 definitions of week of the year (but supports only 2 of them on input) and 2 definitions of weekday … Read more