Excel DATEVALUE is a Date and time function, and its purpose is to converts a date in the form of text to a serial number. Learn how to use it.

For example, the DATEVALUE function in the Date & Time category also returns a numeric value, which is the serial representation of a character string.

We have a program that a lot of people uses and when you export data into comma delimeted files it doesn't export the date correctly. This is how it exports the date:<BR><BR>20040713<BR><BR>As you can ...