DATEVALUE Function (VisioShapeSheet)

Office 2013 and later

Last modified: March 09, 2015

Applies to: Office 2013 | Visio 2013

In this article
Syntax
Remarks
Example 1
Example 2
Example 3
Example 4

Returns the date value represented by datetime or expression.

DATEVALUE("datetime"|expression[,lcid])

Parameters

Name

Required/Optional

Data Type

Description

datetime

Required

String

Any string commonly recognized as a date and time or a reference to a cell containing a date and time.

expression

Required

String

Any expression that yields a date and time.

lcid

Optional

Number

Specifies the locale identifier to be used in evaluating a non-local datetime. The locale identifier is a number described in the system header files.

Return Value

Datetime

Any time component in datetime or expression is discarded.

If datetime is missing or cannot be converted to a valid result, DATEVALUE returns a #VALUE! error.

The returned value is displayed using the short date style set by the system's current Regional Settings.

The DATEVALUE function also accepts a single number value for expression where the integer portion of the result represents the days since December 30, 1899.

DATEVALUE(NOW( ))+5 ed.

Returns the date five days from now.

DATEVALUE("7/19/1995 12:30")

Returns the date.

DATEVALUE("May 33, 1997")

Returns a #VALUE! error.

DATEVALUE(35580.6337)

Returns 5/30/1997.

Show: