DATETOEXCELSERIES: Date to excel date series function

In ExcelFunctionsR: Imports Excel Functions to R

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

DATETOEXCELSERIES(DATE(2020,1,1))

ExcelFunctionsR documentation built on July 1, 2020, 8:35 p.m.