# Format issue dates google sheets

**URL:** <https://community.thunkable.com/t/format-issue-dates-google-sheets/1588577>\
**Category:** Questions about Thunkable X\
**Created:** [October 30, 2021, 2:34am UTC](https://community.thunkable.com/t/format-issue-dates-google-sheets/1588577 "2021-10-30T02:34:29Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\
**Post date:** [October 30, 2021, 3:31am UTC](https://community.thunkable.com/t/format-issue-dates-google-sheets/1588577/3 "2021-10-30T03:31:48Z")

</div>

If you are storing the date in Google sheet using the block `seconds since 1970` then you can use my solution in this post to turn it to normal date (note the last part of adding 5:30 hours is to adjust it for Indian local time)

> [@Open Weather Map Sunrise/Set Parsing](https://community.thunkable.com/t/open-weather-map-sunrise-set-parsing/1170832/12):
>
> This one is easy because Thunkable is using seconds since 1970 and what I do is connect a Google sheet as my data source and this sheet has two columns Unix-time and normal-time In the column normal time I have a formula =A2/86400+DATE(1970,1,1)+TIME(5,30,0) Then in Thunkable I update cell A2 and read cell B2 which has my answer. I use it to compute number of dates between two dates and other date functions.

---

_[View the full topic](https://community.thunkable.com/t/format-issue-dates-google-sheets/1588577)._