Dates are not imported correctly from an Excel feed

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

A date value displayed in an Excel cell

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:

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

Liquid formula configured in the Stockeo Data Mapping section to convert an Excel serial date into a formatted date value

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