deepcalc
DocsEPOCHTODATE

EPOCHTODATE

View as markdown/docs/functions/epochtodate.md Ask Claude about this pageOpens Claude with this page's address

Converts a unix timestamp to a date serial.

  • Excel: No equivalent
  • Google Sheets: Not checked yet
  • Returns: Number

Examples

=EPOCHTODATE(86400)
Result 25570

Syntax

EPOCHTODATE(timestamp, [unit])
timestamp
number required
unit
number optional defaults to 1
DATECreates date from year, month, day. DATEDIFCalculates difference between two dates. DATEVALUEConverts date text to serial number. DAYReturns day of month from date. DAYSReturns number of days between two dates. DAYS360Returns days between dates on 360-day year.