XLDateToPOSIXct(x, tz = "GMT")
as.POSIXct
.XLGetRange
will return dates as integer values, because XL stores them as integers. An Excel date can be converted with the (unusual) origin of
as.Date(myDate, origin="1899-12-30")
, which is implemented here.as.POSIXct
XLDateToPOSIXct(41025)
XLDateToPOSIXct(c(41025.23, 41035.52))
Run the code above in your browser using DataLab