openxlsx: convertToDate – R documentation

Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!

convertToDate

Convert from excel date number to R Date type

Convert from excel date number to R Date type

convertToDate(x, origin = "1900-01-01", ...)

`x`	A vector of integers
`origin`	date. Default value is for Windows Excel 2010
`...`	additional parameters passed to as.Date()

Excel stores dates as number of days from some origin day

## 2014 April 21st to 25th
convertToDate(c(41750, 41751, 41752, 41753, 41754, NA))
convertToDate(c(41750.2, 41751.99, NA, 41753))

Read, Write and Edit xlsx Files

v4.2.3

MIT + file LICENSE

Authors

Philipp Schauberger [aut, cre], Alexander Walker [aut], Luca Braglia [ctb], Joshua Sturm [ctb]

Initial release

2020-10-26