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)
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)