Description Usage Arguments Details Value See Also Examples
Converts numbers like 42370
into date values like
20160101
.
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 20160101 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/enus/article/DatecalculationsinExcele7fe716748a94b96bb535612a800b487.
A list of all timezones is available from base::OlsonNames()
, and the
current timezone is available from base::Sys.timezone()
.
If your input data has a mix of Excel numeric dates and actual dates, see the
more powerful functions convert_to_date()
and convert_to_datetime()
.
1 2 3 4 5 6 7  excel_numeric_to_date(
date_num,
date_system = "modern",
include_time = FALSE,
round_seconds = TRUE,
tz = ""
)

date_num 
numeric vector of serial numbers to convert. 
date_system 
the date system, either 
include_time 
Include the time (hours, minutes, seconds) in the output? (See details) 
round_seconds 
Round the seconds to an integer (only has an effect when

tz 
Time zone, used when 
When using 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
https://support.microsoft.com/enus/help/2722715/supportfortheleapsecond).
Returns a vector of class Date if include_time
is
FALSE
. Returns a vector of class POSIXlt if include_time
is
TRUE
.
Other Datetime cleaning:
convert_to_date()
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

[1] "20090706"
[1] "20090706"
[1] "20090706 12:00:00"
[1] "20090706 12:30:14"
[1] "20090706 12:30:14"
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.