---
id: "excel_serial_date"
kind: "pattern"
status: "draft"
is_pii: false
categories: ["datetime"]
langs: ["common"]
quality: 85
url: "https://registry.apicrafter.io/datatype/excel_serial_date"
---

# Date as an Excel serial number (`excel_serial_date`)

> **Draft.** Draft records have not been reviewed yet and may be incomplete or wrong; do not treat them as authoritative for legal or compliance decisions.

Date written as the serial day number of spreadsheets, days since 30 December 1899, as in 36872 for 12 December 2000. Data exported from sheets without the date format keeps it.

- Pattern of: `date`
- Personal data (PII): no
- Categories: Date and time (datetime)
- Countries: global
- Languages: Common to most languages (common)

## Detection

Regular expression (Python `re`):

```
^\d{5}$
```

## Examples

- `36872` — 12 December 2000
- `42367` — 29 December 2015
- `2015-12-29` (invalid example)

## Metacrafter rules

1 rules: 0 match the field name, 1 match values.

- `excelserialdatevalue` (data, `common/dateandtime.yaml`)

## Supported by tools

- `metacrafter`

## Sources

- wikipedia: <https://en.wikipedia.org/wiki/Spreadsheet>

## Quality

Score 85/100. Missing: mapping (Wikidata, Schema.org, ...), translation.

JSON: <https://registry.apicrafter.io/api/v1/datatypes/excel_serial_date.json> · Edit: <https://github.com/apicrafter/metacrafter-registry/edit/main/data/datatypes/any/datetime/excel_serial_date.yaml>