Date as an Excel serial number
ID excel_serial_date
Pattern of dateNot PIIDraft
This record is a draft: it has not been reviewed yet and may be incomplete or wrong. Do not rely on it for compliance decisions. Help improve it (see CONTRIBUTING.md).
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
date - Categories
- Date and time
- Countries
- Global (not tied to a country)
- Languages
- Common to most languages
- Quality
- 85/100 · missing: mapping (Wikidata, Schema.org, ...), translation
- Metacrafter rules
- 1 rule (0 by field name, 1 by value)
excelserialdatevaluedata, common/dateandtime.yaml
- Supported by tools
- metacrafter
Regular expression
^\d{5}$Python re syntax.
Examples
| Value | Description |
|---|---|
| 36872 | 12 December 2000 |
| 42367 | 29 December 2015 |
| 2015-12-29 invalid |
Sources
- wikipedia: https://en.wikipedia.org/wiki/Spreadsheet
Use this record
- Page URL:
https://registry.apicrafter.io/datatype/excel_serial_date - JSON: API v1 · legacy shape (used by metacrafter) · Markdown (for LLMs)
- Improve it: edit
data/datatypes/any/datetime/excel_serial_date.yamlon GitHub