Converts Excel dates encoded as serial numbers to date class.
dtt_excel_to_date(x, modern = TRUE, ...)
A vector of numbers to convert.
A flag specifying whether to use the modern or old Excel date system.
Unused.
A floored Date vector.
Defaults to the modern Excel date encoding system. Excel for Mac 2008 and earlier Mac versions of Excel use a different date system. If the date 2016-01-01 is represented by 42370, it's the modern system. If it's 40908, it's the old system.
Other floor:
dtt_date_time()
,
dtt_date()
,
dtt_floored()
,
dtt_floor()
,
dtt_set_time()
dtt_excel_to_date(42370)
#> [1] "2016-01-01"
dtt_excel_to_date(40908, modern = FALSE)
#> [1] "2016-01-01"