i have numeric dates after read_xlsx file as below
head(df$Hire_date,10)
[1] "35078" "32653" "33226" "34261" "30800" "27591" "32440" "31597" "30979" "28484"
i want to convert it to format "31-12-2019" , i have tried below options but doesn't work
df$Hire_date <- as.Date(df$Hire_date,format = "%d%b%Y")
as.Date(x, "%d%b%Y")
DOB <-format(DOB,"ymd","%Y-%m-%d")
Hire_date <- format(DOB,"ymd","%Y-%m-%d")