UNIXDATE

Creates a date from the number of seconds since the Unix epoch (January 1, 1970, 00:00:00 UTC).

Syntax

=UNIXDATE(value)

Arguments

Argument	Type	Description
value	Number	number of seconds

Examples

=UNIXDATE(1593561600)→Jun 30, 2020 6:00 PM

=UNIXDATE(1607136108)→Dec 4, 2020 7:41 PM