# Date serial number to normal date

**URL:** <https://community.n8n.io/t/date-serial-number-to-normal-date/10891>\
**Category:** Questions\
**Tags:** data-transformation\
**Created:** [January 25, 2022, 12:26pm UTC](https://community.n8n.io/t/date-serial-number-to-normal-date/10891 "2022-01-25T12:26:48Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![MutedJam](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/mutedjam/32/70851_2.png) [@MutedJam](https://community.n8n.io/u/MutedJam)\
**Post date:** [January 26, 2022, 10:34am UTC](https://community.n8n.io/t/date-serial-number-to-normal-date/10891/4 "2022-01-26T10:34:15Z")

</div>

Many thanks! Looking at these number I assume this is the data format used by Microsoft Excel? Unfortunately, n8n doesn’t have a built in option to convert these.

If you control the source sheet, you could explicitly store these values as texts rather than date values.

If that’s not an option and you need to convert these values in n8n, you could use a [Set](https://docs.n8n.io/nodes/n8n-nodes-base.set/) node and an expression like `{{new Date(Math.round($json["Created at"] - 25569) * 86400 * 1000)}}` (found [here](https://stackoverflow.com/a/22352911)). This would convert the Excel value in a Date value understood by n8n:

 ![image](https://europe1.discourse-cdn.com/n8n/original/2X/0/064e416edad70e168aa2ab939c11cd5233f8b7ba.png)

Hope this helps! Let me know if you have any further queries on this 🙂

---

_[View the full topic](https://community.n8n.io/t/date-serial-number-to-normal-date/10891)._