> 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="/files/75RDlumNweSEjGuIqH3o" 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="/files/XPBlzXTZe22HHcl58ZGw" 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.