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.
blueprint.json (7.2 KB)