# Parse Google Sheets Serial Number

**URL:** <https://community.make.com/t/parse-google-sheets-serial-number/49590>\
**Category:** Questions\
**Tags:** google-sheets\
**Created:** [August 5, 2024, 2:54pm UTC](https://community.make.com/t/parse-google-sheets-serial-number/49590 "2024-08-05T14:54:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Atishay\_Jain](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@Atishay\_Jain](https://community.make.com/u/Atishay_Jain)\
**Post date:** [August 5, 2024, 2:54pm UTC](https://community.make.com/t/parse-google-sheets-serial-number/49590/1 "2024-08-05T14:54:07Z")

</div>

Trying to parse Google Sheets unformatted date time serial number on Make.  
Saw this post and tried multiplying the value by 86400 before parsing it.

But it’s giving a future date time.

I tried parsing 45479 like this {{parseDate(45479 \* 86400; “X”)}}  
The flow returned July 8, 2094 5:30 AM even though it’s supposed to mean 6 July 2024 00:00 IST.

P.S. Google Sheets seems to be converting serial number 1 to 31/12/1899 00:00:00

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/c/bccdd7d78c0e33dc4a3dd1b12e91702398d54c21.jpeg)  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/8/38353885ca1326a88967622d5344120739538626.jpeg)

> [@How to convert excel date (E.g. 45000) so it can be compared in make?](https://community.make.com/t/how-to-convert-excel-date-e-g-45000-so-it-can-be-compared-in-make/43614/1):
>
> Hi Team,
> 
> I am working with the List\_Table\_Rows Excel module. For a date column, it returns numbers like 46792 to represent 05/07/2024.
> 
> My question is how can I convert 46792 into a usable format so it can be used in Filers. (E.g. DateTime Operators Later then)
> 
> Thanks for your help!

---

<div class="post-metadata">

**Author:** ![ImMichaelCannon](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/immichaelcannon/32/48674_2.png) [@ImMichaelCannon](https://community.make.com/u/ImMichaelCannon)\
**Post date:** [August 6, 2024, 6:43am UTC](https://community.make.com/t/parse-google-sheets-serial-number/49590/2 "2024-08-06T06:43:16Z")

</div>

Welcome @Atishay_Jain.

Google Sheets date serial is the number of days since December 31, 1899.

For example, January 12, 2021 is stored as 44208.

One option is to format the date in Google Sheets and that’ll often carry through Google Sheet module calls.

The next is to is recognize the difference between Google Sheets time start and Unix’s timestamp of 25569 days.

So we need to decrease the given Google Sheets serial date by Unixtime start equivalent, and convert that result by seconds in days. Finally, we can get the Unixtime and nicely display it.

My example below sets a few times to check, and converts them from Google Serial to Unixtime.

 ![Scenario Google Sheets Serial Date Conversion](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/b/2b0687daad68460ccbb22f578fdd2cad697b1e3b.png)  
 ![Days in Seconds & Unix Timestamp Start](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/f/ef1ca0227f5e24226fb230e0545a42823b90a396.png)  
 ![Serial dates to process](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/6/16d19c101b950f054a602f95f59932fc736a7d9b.png)  
 ![Serial Date Conversion](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/0/d02dad147c7966a7e090da2cbed051b2ccf7d5cf.png)  
 ![Serial Dates as Pretty Dates](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/1/e127bdf62a345f05955e1f372d78f2a097f1d7de.jpeg)

[blueprint.json](https://community.make.com/uploads/short-url/bBS7PkDr4WSnWcGrZC7JOaedosy.json) (7.2 KB)

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [October 3, 2024, 6:37pm UTC](https://community.make.com/t/parse-google-sheets-serial-number/49590/3 "2024-10-03T18:37:22Z")

</div>