Search code examples
rexcellubridatewritexl

What is the correct date format for writexl

What is the correct date format for the new writexl package? I tried it on lubridate dates, and the resulting Excel spreadsheet contains strings of the form yyyy-mm-dd (i.e. not Excel dates).

Solution

  • It worked when I converted my dates to POSIXct dates using as.POSIXct.