ExcelFunctionsR (version 0.1.4)

DATETOEXCELSERIES: Date to excel date series function

Description

Functions converts dates to Excel General date series which might be useful when writing Excel files.

Usage

DATETOEXCELSERIES(date)

Arguments

date

Convert R date type to Excel general date series, this might be helpful for Excel users.

Value

In this example it returns the Excel's general date series equivalent of date 1st January of 2020. Function will always return numeric class.

Examples

# NOT RUN {
DATETOEXCELSERIES(DATE(2020,1,1))
# }