Functions

EPOCHTODATE

Converts Unix timestamp to date serial number

Try it

When to use it

When should I use EPOCHTODATE?

Use EPOCHTODATE to convert a Unix timestamp (seconds or milliseconds since 1970-01-01) into a spreadsheet date serial number for display or further date calculations.

Used in

operations

Syntax

EPOCHTODATE(timestamp,[unit])

Examples

=EPOCHTODATE(1655906568893,2) // => 44734.58528811343
=EPOCHTODATE(1655906710,1) // => 44734.5869212963
=EPOCHTODATE(0,2) // => 25569

EOMONTH

Last day of month N months from start date

ERF

Error function