Formualizer Docs
ReferenceFunctionsDate & Time Functions

DATEVALUE

DATEVALUE: Parses a date string and returns its date serial number.

Summary

Parses a date string and returns its date serial number.

Remarks

  • Accepted formats are a fixed supported subset (for example YYYY-MM-DD, MM/DD/YYYY, and month-name forms).
  • Parsing is not locale-driven; ambiguous text may parse differently than Excel locales.
  • Output uses Excel 1900 serial mapping and does not currently switch to workbook 1904 mode.

Examples

Parse ISO date
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
45306
Parse month-name date
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
45306

FAQ

Why can DATEVALUE disagree with locale-specific Excel parsing?

This implementation uses a fixed set of accepted formats instead of workbook locale settings, so ambiguous text may parse differently.

Runtime metadata

Category

Date & Time

Signature

DATEVALUE(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

crates/formualizer-eval/src/builtins/datetime/date_value.rs

DATEDIF

DATEDIF: Returns the difference between two dates in a requested unit.

DAY

Extracts the day-of-month (`1` to `31`) from a date serial.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy can DATEVALUE disagree with locale-specific Excel parsing?Runtime metadata