> For the complete documentation index, see [llms.txt](https://help.stockeo.solvenium.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.stockeo.solvenium.com/troubleshooting/dates-are-not-imported-correctly-from-an-excel-feed.md).

# Dates are not imported correctly from an Excel feed

Assume a date in Excel is displayed in the following format:

<figure><img src="https://2071801931-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fz6HyRe5TyFXHKQEybH7n%2Fuploads%2FpDExJszdHqw0aahTw7IB%2Fexcel-date-cell.png?alt=media&amp;token=96fdcf9e-e641-48ad-a5b1-c3019eae2b67" alt="Date displayed in an Excel cell"><figcaption><p>A date value displayed in an Excel cell</p></figcaption></figure>

However, the actual value passed to Shopify by Stockeo is `46183`. This is because Excel stores dates as serial numbers. In this example, the value represents the number of days since `1900-01-01`, which corresponds to the date `2026-06-10`.

To convert the value into a readable date format, a Liquid formula must be applied. Since Liquid supports Unix timestamps, which are based on `1970-01-01`, the formula first subtracts the number of days between `1900-01-01` and `1970-01-01` (`25569`) from the Excel date value. It then multiplies the result by the number of seconds in a day (`86400`) to obtain a Unix timestamp and finally formats the timestamp using the Liquid `date` filter.

If the date is stored in column **B**, the formula should be:

```liquid
{{ B | minus: 25569 | times: 86400 | date: "%Y-%m-%d" }}
```

<figure><img src="https://2071801931-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fz6HyRe5TyFXHKQEybH7n%2Fuploads%2FwiutKyqCLNWKZjrvwMVZ%2Fstockeo-data-mapping-excel-date-conversion.png?alt=media&amp;token=9c1fbd46-7776-4d1a-aea8-880fca8a1d7e" alt="Liquid formula configured in the Stockeo Data Mapping section to convert an Excel serial date into a formatted date value"><figcaption><p>Liquid formula configured in the Stockeo Data Mapping section to convert an Excel serial date into a formatted date value</p></figcaption></figure>

This formula converts the Excel serial date into a Unix timestamp and outputs it in the format specified by the Liquid `date` filter.