Converts numbers like
42370 into date values like
Defaults to the modern Excel date encoding system. However, Excel for Mac 2008 and earlier Mac versions of Excel used a different date system. To determine what platform to specify: if the date 2016-01-01 is represented by the number 42370 in your spreadsheet, it's the modern system. If it's 40908, it's the old Mac system. More on date encoding systems at http://support.office.com/en-us/article/Date-calculations-in-Excel-e7fe7167-48a9-4b96-bb53-5612a800b487.
A list of all timezones is available from
base::OlsonNames(), and the
current timezone is available from
If your input data has a mix of Excel numeric dates and actual dates, see the
more powerful functions
1 2 3 4 5 6 7
numeric vector of serial numbers to convert.
the date system, either
Include the time (hours, minutes, seconds) in the output? (See details)
Round the seconds to an integer (only has an effect when
Time zone, used when
include_time=TRUE, days with leap seconds will not
be accurately handled as they do not appear to be accurately handled by
Windows (as described in
Returns a vector of class Date if
FALSE. Returns a vector of class POSIXlt if
Other Date-time cleaning:
1 2 3 4 5 6
excel_numeric_to_date(40000) excel_numeric_to_date(40000.5) # No time is included excel_numeric_to_date(40000.5, include_time = TRUE) # Time is included excel_numeric_to_date(40000.521, include_time = TRUE) # Time is included excel_numeric_to_date(40000.521, include_time = TRUE, round_seconds = FALSE) # Time with fractional seconds is included
 "2009-07-06"  "2009-07-06"  "2009-07-06 12:00:00"  "2009-07-06 12:30:14"  "2009-07-06 12:30:14"
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.