Description Usage Arguments Value Note Examples
Excel stores dates as an integer representing the number of days since 1/1/1900. Undo that. See http://www.exceltactics.com/definitive-guide-using-dates-times-excel/
1 | undo_excel_date(dates)
|
dates |
a vector of dates (either numeric or character) originating from an Excel spreadsheet. |
the dates converted to POSIXct objects (see base::DateTimeClasses)
This function is only valid for years 1901 and beyond. Excel wrongly
assumes 1900 was a leap year. See base::format.Date()
for more
information.
1 2 3 4 | undo_excel_date("41659")
#> "2014-01-20 UTC"
undo_excel_date(41534)
#> "2013-09-17 UTC"
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.