How to convert Excel date format to proper date in R

by

You don’t need to use lubridate for this, the base function as.Date handles this type of conversion nicely. The trick is that you have to provide the origin, which in Excel is December 30, 1899.

as.Date(42705, origin = "1899-12-30")
# [1] "2016-12-01"

If you want to preserve your column types, you can try using the read_excel function from the readxl package. That lets you load an XLS or XLSX file with the number formatting preserved.

More Related Contents:

  1. How to flatten / merge overlapping time periods
  2. How to prevent ifelse() from turning Date objects into numeric objects
  3. Transform year/week to date object
  4. Convert date-time string to class Date
  5. Split date-time column into Date and time variables
  6. Generate a sequence of the last day of the month over two years
  7. efficiently generate a random sample of times and dates between two dates
  8. Is there a more elegant way to convert two-digit years to four-digit years with lubridate?
  9. Add (subtract) months without exceeding the last day of the new month
  10. How to determine if date is a weekend or not (not using lubridate)
  11. Change day of the month in a Date to first day (01)
  12. Checking if Date is Between two Dates in R
  13. extract hours and seconds from POSIXct for plotting purposes in R
  14. Calculating Time Difference between two columns
  15. Convert decimal day to HH:MM
  16. Convert two-digit years to four-digit years with correct century
  17. Create a Vector of All Days Between Two Dates
  18. Round a POSIX date (POSIXct) with base R functionality
  19. Split date into different columns for year, month and day
  20. Converting Date formats in R [closed]
  21. Convert seconds to days: hours:minutes:seconds
  22. Understanding dates and plotting a histogram with ggplot2 in R
  23. Assigning Dates to Fiscal Year
  24. convert character to date *quickly* in R [duplicate]
  25. Rounding time to nearest quarter hour
  26. Is it possible to get the number of rows in a CSV file without opening it?
  27. Subset data.frame by date
  28. as.Date(as.POSIXct()) gives the wrong date?
  29. R datetime series missing values
  30. How to calculate time difference with previous row of a data.frame by group

Leave a Comment