GitHub - cran/unexcel: :exclamation: This is a read-only mirror of the CRAN R package repository. unexcel — Revert Excel Serial Dates Back to Intended Day.Month Numerics. Homepage: https://github.com/drhrf/unexcel Report bugs for this package: https://github.com/drhrf/unexcel/issues

cran / unexcel Public

Notifications You must be signed in to change notification settings
Fork 0
Star 0

❗ This is a read-only mirror of the CRAN R package repository. unexcel — Revert Excel Serial Dates Back to Intended Day.Month Numerics. Homepage: https://github.com/drhrf/unexcel Report bugs for this package: https://github.com/drhrf/unexcel/issues

View license

0 stars 0 forks Branches Tags Activity

Star

Notifications

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 1 Commit
R		R
build		build
inst/doc		inst/doc
man		man
vignettes		vignettes
DESCRIPTION		DESCRIPTION
LICENSE		LICENSE
MD5		MD5
NAMESPACE		NAMESPACE
README		README

Repository files navigation

# unexcel

Detect and revert spreadsheet auto-converted Excel date serials back to the intended `day.month` numerics.  

This package provides functions to identify values imported as Excel date serials (for example, `45812` representing 2025-03-30) and reconstruct the original numeric entry such as `30.3`. Non-serial values are preserved, and both the 1900 and 1904 date systems are supported.

## Installation

You can install the development version from GitHub with:

```r
# install.packages("remotes")
remotes::install_github("drhrf/unexcel")
```

## Example

```r
library(unexcel)

# 45812 is 2025-03-30 in Excel's 1900 system
x <- c(45812, 12.5, 44730)

restore_day_month(x, origin_mode = "1900")
#> [1] 30.3 12.5 15.6
```