deepcalc
DocsDATEVALUE

DATEVALUE

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

Converts date text to serial number.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Number (date serial)

Examples

=DATEVALUE("2026-07-27")
Result 46230

Syntax

DATEVALUE(date_text)
date_text
text required

Errors

#VALUE!
=DATEVALUE("alpha")
DATECreates date from year, month, day. DATEDIFCalculates difference between two dates. DAYReturns day of month from date. DAYSReturns number of days between two dates. DAYS360Returns days between dates on 360-day year. EDATEReturns date shifted by given months.