datevalue

Parse a date string into a serial date number.

Syntax

v = datevalue(date_text)

Description

Parses common date formats ('2026-04-28', '04/28/2026', '28-Apr-2026', etc.) and returns the serial date number. Raises #VALUE! on unparseable input.

Example

datevalue('2026-04-28')

See also

• date — Construct a date serial number from year, month, day.
• timevalue — Parse a time string into a fraction of a day.
• value — Convert a text string to a number.