How to convert Excel serial date to POSIXct in R (i.e. 42309 = 2015-11-01)

If you are converting a column of Excel serial dates in a dataframe:

> df$yourDates <- as.POSIXct(as.Date(df$yourDates, origin = “1899-12-30”)) [1] [POSIXct dates]

… or …

If you are converting a single Excel serial date:

> mydate = as.POSIXct(as.Date(42309, origin = “1899-12-30”))
[1] 2015-11-01

Note: This solution requires the lubridate package.

 
1
Kudos
 
1
Kudos

Now read this

How to read data from an Excel .xlsx file in R

To read directly from a .xlsx in the same directory as your R script: > data <- read.xlsx(“yourdata.xlsx”) … or … To read from a workspace directory containing a .xlsx file: > wdir = “C:/workspace/yourdirectory” > data <-... Continue →