DATEVALUE function - The function converts dates into numbers in Excel

The following article details how to use the DATEVALUE function, the function converts dates to numbers in Excel.

DATEVALUE function - The function converts dates into numbers in Excel Picture 1

Description: The function performs converting text dates into serial numbers that Excel understands.

Syntax: DATEVALUE (date_text) .

Inside:

date_text is the date in the form of the text you want to convert to a number, which is a required parameter.

Attention:

- This argument must be between January 1, 1900 and December 31, 9999. Outside of this range, the function returns the #VALUE! Error value.

- If the date_text argument does not contain five functions, get the current year on your computer. - The default January 1, 1900 has a serial number of 1 and January 1, 2008 serial number is 39448 because it is stored at 39447.

For example:

Putting employees' birth dates on the serial number can be used to evaluate the employee's age.

DATEVALUE function - The function converts dates into numbers in Excel Picture 2

- For example, the employee Pham Van Anh in the cell to calculate the formula: = DATEVALUE ("January 8, 1982") .

DATEVALUE function - The function converts dates into numbers in Excel Picture 3

Press Enter -> serial number result is:

DATEVALUE function - The function converts dates into numbers in Excel Picture 4

In the above case, you cannot enter the formula: = DATEVALUE ("1/1/1992") -> the function returns the #VALUE! Error value.

DATEVALUE function - The function converts dates into numbers in Excel Picture 5

Copying the formula for the remaining value results in:

DATEVALUE function - The function converts dates into numbers in Excel Picture 6

- In case you enter the date value in 3 different columns you can do the following: In the cell to calculate the formula: = DATEVALUE (E9 & "/" & F9 & "/" & G9) .

DATEVALUE function - The function converts dates into numbers in Excel Picture 7

Press Enter -> the date value corresponding to the serial number is:

DATEVALUE function - The function converts dates into numbers in Excel Picture 8

Copying the formula for the remaining values ​​results in:

DATEVALUE function - The function converts dates into numbers in Excel Picture 9

Based on visual serial numbers, it is possible to compare older employees and potential young employees.

The above is the usage as well as some special cases when using the DATEVALUE function .

Good luck!