# DATEVALUE

## Content

This function returns a DateTime object of the specified date.

## Syntax

`DATEVALUE( date_string )`

## Arguments

The argument for this function is a date as a string.

## Remarks

Use this function to convert a date represented by text to a DateTime object in a standard format.

## Data Types

Accepts string data. Returns a DateTime object.

## Examples

`DATEVALUE(B18)`

`DATEVALUE(R18C2)`

`DATEVALUE("2004/10/6")` gives the result 10/6/2004 12:00:00 AM