- Formula Reference
- Contacting Us
- Getting Technical Support
- Formula Overview
-
Formula Functions
- Functions A to C
-
Functions D to G
- DATE
- DATEDIF
- DATEVALUE
- DAVERAGE
- DAY
- DAYS
- DAYS360
- DB
- DBCS
- DCOUNT
- DCOUNTA
- DDB
- DEC2BIN
- DEC2HEX
- DEC2OCT
- DECIMAL
- DEGREES
- DELTA
- DEVSQ
- DGET
- DISC
- DMAX
- DMIN
- DOLLAR
- DOLLARDE
- DOLLARFR
- DPRODUCT
- DROP
- DSTDEV
- DSTDEVP
- DSUM
- DURATION
- DVAR
- DVARP
- EDATE
- EFFECT
- ENCODEURL
- EOMONTH
- ERF
- ERF.PRECISE
- ERFC
- ERFC.PRECISE
- ERROR.TYPE
- ERRORTYPE
- EURO
- EUROCONVERT
- EVALUATE
- EVEN
- EXACT
- EXP
- EXPAND
- EXPON.DIST
- EXPONDIST
- F.DIST
- F.DIST.RT
- F.INV
- F.INV.RT
- F.TEST
- FACT
- FACTDOUBLE
- FALSE
- FDIST
- FIELDVALUE
- FILTER
- FILTERXML
- FIND
- FINDB
- FINV
- FISHER
- FISHERINV
- FIXED
- FLOOR
- FLOOR.MATH
- FLOOR.PRECISE
- FORECAST
- FORECAST.LINEAR
- FORECAST.ETS
- FORECAST.ETS.CONFINT
- FORECAST.ETS.SEASONALITY
- FORECAST.ETS.STAT
- FORMULATEXT
- FREQUENCY
- FTEST
- FV
- FVSCHEDULE
- GAMMA
- GAMMA.DIST
- GAMMA.INV
- GAMMADIST
- GAMMAINV
- GAMMALN
- GAMMALN.PRECISE
- GAUGEKPISPARKLINE
- GAUSS
- GCD
- GEOMEAN
- GESTEP
- GROWTH
- Functions H to L
- Functions M to Q
- Functions R to S
- Functions T to Z
DATEVALUE
This function returns the serial number of a date entered as text.
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 a text string to an Excel serial number that can be used to perform calculations.
Data Types
Accepts string data. Returns an excel serial number as date.
Examples
DATEVALUE(B18)
DATEVALUE(R18C2)
DATEVALUE("2019/02/13") gives the result 43509.
Version Available
This function is available in product version 1.0 or later.
!type=note
Note: If a user uses LegacyBehaviors.CalculationEngine, DATEVALUE function will return the DateTime object instead of the serial numeric value.