convertToDate: Convert from excel date number to R Date type
In openxlsx: Read, Write and Edit xlsx Files
convertToDate R Documentation
Convert from excel date number to R Date type
Description
Convert from excel date number to R Date type
Usage
convertToDate(x, origin = "1900-01-01", ...)
Arguments
x
A vector of integers
origin
date. Default value is for Windows Excel 2010
...
additional parameters passed to as.Date()
Details
Excel stores dates as number of days from some origin day
See Also
writeData()
Examples
## 2014 April 21st to 25th
convertToDate(c(41750, 41751, 41752, 41753, 41754, NA))
convertToDate(c(41750.2, 41751.99, NA, 41753))
openxlsx documentation built on Feb. 16, 2023, 6:47 p.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
| convertToDate | R Documentation |
Convert from excel date number to R Date type
Description
Convert from excel date number to R Date type
Usage
convertToDate(x, origin = "1900-01-01", ...)
Arguments
x |
A vector of integers |
origin |
date. Default value is for Windows Excel 2010 |
... |
additional parameters passed to as.Date() |
Details
Excel stores dates as number of days from some origin day
See Also
writeData()
Examples
## 2014 April 21st to 25th convertToDate(c(41750, 41751, 41752, 41753, 41754, NA)) convertToDate(c(41750.2, 41751.99, NA, 41753))
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.