Convert mixed format dates to Microsoft Excel serial dates

Converts string dates that may be in serial (using the Microsoft Excel offset), "m/d/y" (e.g., "01/31/00"), or "m/d/Y" format (e.g., "01/31/2000") into numeric serial dates. Two-digit years are expanded using a specified century and pivot year.

Usage

OR.mdyY.to.Excel(input, century, pivot)

Arguments

input

String vector of dates in serial, "m/d/y" or "m/d/Y" format.

century

Numeric century (e.g., 20) used for expanding two-digit years.

pivot

Numeric threshold where two-digit years > pivot are expanded with century - 1.

Value

Numeric vector of serial dates using the Microsoft Excel offset.

See also

Other Excelserialdates: OR.dmyY.to.Excel()

Examples

print(OR.mdyY.to.Excel(c("01/31/00", "01/31/2000", "36556"), 20, 25))
#> [1] 36556 36556 36556