How to Use EPOCHTODATE() in Google Sheets

Description

Converts a Unix epoch timestamp in seconds, milliseconds, or microseconds to a datetime in UTC.

How To Actually Use EPOCHTODATE() in Sheets

EPOCHTODATE(timestamp, [unit])

Try EPOCHTODATE yourself

Use EPOCHTODATE to convert the Unix timestamp in A2 (seconds) into a UTC datetime. Place the formula in B2.

Your formula

Hints (3)

Locale Separator ,

Official Docs

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Transcript-matched member videos for EPOCHTODATE(). Click through to watch.

Browse more tutorials

How Many Days Between Two Dates?

Figure out how many days between two days, or how many days until a cert...

Intermediate

DATE() DATEDIF()

Google Sheets Interface Changes

Showing off New experiences in smart canvas changes to sheets. Including...

Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.

There was a stories craze. Every app/platform/business was adding 24 hou...

CONCATENATE() IF() IMAGE() INDEX() ISBLANK() +1 more

Unlock these tutorials

Learn more about the EPOCHTODATE() formula:

Generate a EPOCHTODATE() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses EPOCHTODATE(). 2 free AI generations, no signup. Members get unlimited use.

Generate a EPOCHTODATE() formula

How to Use EPOCHTODATE() in Google Sheets

Try EPOCHTODATE yourself

More related tutorials

How Many Days Between Two Dates?

Google Sheets Interface Changes

Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.