DATEVALUE function. Converts a string date to a serial value.(Microsoft Excel)
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.
Contents
How it works
=DATEVALUE(Date_text)
| Argument | Omission | Specify |
|---|---|---|
| Date_text | Required 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)
Spill
If you specify the argument the cell range, it will be Spill.
---