Menu
EXCEL DATEVALUE FUNCTION
Excel DATEVALUE Function Introduction
This function will convert a date in text format to a valid date and returns a serial number that represents a particular date in Excel.
Description of Excel DATEVALUE Function
Syntax:
=DATEVALUE (date_text)
Parameter list:
date_text – a valid date in text format. If date_text is a cell address, value of the cell must be text. If date_text is entered directly into the formula it must be enclosed in quotes.
Step By Step Guide of DATEVALUE Function
You can see in the last calculation we have used the & character to join all the dates as text in order to give the argument as text.
Excel is storing the dates as serial numbers starting from 01/01/1900 means the first day of Jan 1900 is the day one and 2nd Jan 1900 is day 2 like that. So if you want to get the serial number of a date entered as text you can use this function.
Key Points
Will return a #VALUE error if date_text refers to a cell that does not contain a date formatted as text.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
