My solution? A script that changes the excel dates back into numbers- currently optimised for my purposes but could easily be changed to do other things. The name is not work safe- it represents my frustration with Microsoft, but has been sanitised prior to posting in this forum (hint: replace the "*" with something else )
Code: Select all
excelun***k<-function(x){
emonths<-c("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")
enumeric<-c(1:12)
mnums<-cbind(emonths,enumeric)
for (i in 1:length(x)){
if(length(grep(x[i],emonths))==0){print("ok")}
else{
x[i]<-mnums[grep(x[i],emonths),2]
}}
return(as.numeric(x))
}
excelun***k("Jan")