DATEVALUE function. Converts a string date to a serial value.(Microsoft Excel)

Japanese version.

Converts a string date to a serial value.

This function is used to.

  • Combine strings to create a date.
  • If a date imported from another application is a string.

Since time is truncated, use the VALUE function if you want to include it in the conversion.

How it works

Date_textRequired argument.String to be converted to a serial value.

Example Results

In a Microsoft365 WIndows 11 environment, the results are as follows.

(Operation will vary depending on environment)


If you specify the argument the cell range, it will be Spill.



Date & Time(Microsoft Excel Functions)