excel_numeric_to_date

numeric vector of serial numbers to convert.

date_num

the date system, either <code>"modern"</code> or <code>"mac pre-2011"</code>.

date_system

Converts numbers like <code>42370</code> into date values like <code>2016-01-01</code>.
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.

The main janitor functions can: perfectly format data.frame column
names; provide quick one- and two-variable tabulations (i.e., frequency
tables and crosstabs); and isolate duplicate records. Other janitor functions
nicely format the tabulation results. These tabulate-and-report functions
approximate popular features of SPSS and Microsoft Excel. This package
follows the principles of the "tidyverse" and works well with the pipe function
%>%. janitor was built with beginning-to-intermediate R users in mind and is
optimized for user-friendliness. Advanced R users can already do everything
covered here, but with janitor they can do it faster and save their thinking for
the fun stuff.

Sam Firke

excel_numeric_to_date: Convert dates encoded as serial numbers to Date class.

Description

Usage

Arguments

Value

Examples