How to convert date value string to serial number in Excel

Excel is a commonly used spreadsheet software that can be used to create complex tables. When Excel software processes tabular data, you can use the DATEVALUE function to convert dates stored as text into serial numbers that Excel recognizes as dates. How to convert date value string to serial number in Excel? Let me introduce the method to you below. Setting method 1. First find the Excel document that needs to be edited, double-click to open it and enter the editing interface. 2. Enter table data in the editing area and select a blank cell (for example: cell F11).

3. Enter the =DATEVALUE (2011-8-22) function formula in the cell.

4. Then click the Enter key on the keyboard.

5. Return to the editing area and use the DATEVALUE function in cell F11 to calculate the serial number of the date 2011-8-22.

The above is the detailed content of How to convert date value string to serial number in Excel. For more information, please follow other related articles on the PHP Chinese website!