Excel Date System Fiasco

Embed

  1. I recently discovered a big problem when trying to read some data into R from an .xlsx file. The dates looked right when I opened the Excel file, but when I read them into R they magically shifted by several years.
  2. Cue Hadley Wickham to the rescue:
  3. ...and then my head exploded.
  4. (Stronger gifs were needed.)
  5. So yeah, all of my biases against Excel are now officially justified. It is the WORST.
1
Share

Share

Facebook
Google+