| Syntax |
| =DATEVALUE(date_text) |
| Purpose / Description |
| Returns a serial date number representing the time stored as a string, so long as it is in a recognisable Excel date format (and optionally an Excel recognisable time). |
| Arguments |
| Name |
Type |
Description |
| date_text |
text string |
A constant, reference or nested expression providing a text string containing a date (and optionally a time) in a recognisable Excel date format. |
| Return Values |
| Type |
Specific Value |
Description |
| number |
|
The serial date number that represents the date encoded in the text string if found. |
| error |
#VALUE! |
If the date_text argument is a logical, a number or a text string that does not contain a recognisable date or date and time. |
| error |
|
Any errors referenced by arguments are returned due to propagation of error values. |
| Notes / Comments / Advice / Warnings |
| Comment: |
The VALUE function will return both date and time serial numbers as a single value. |
| Examples: |
Open / download sample workbook: DATEVALUE.xlsx |
| |