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.

Method two is to click the Formulas tab, click the Time and Date button in the Function Library group, and select TIMEVALUE from the drop-down menu. A Function Arguments dialog box will appear.

Excel functions are the building blocks; formulas are how you bring them to life. Here's the breakdown.