Converts a date stored as text into a serial number that Excel recognizes as a date.
Hàm này hoạt động trong Google Sheets giống như trong Excel — cùng cú pháp và đối số.
DATEVALUE(date_text)The DATEVALUE function is useful when a worksheet contains dates in a text format that you want to use in calculations. It returns the serial number representing the date according to Excel's date-time system. If the date_text argument includes year information, it is used; otherwise, it defaults to the current year.
=DATEVALUE("2023-01-01")Kết quả: 44927
Converts the text string '2023-01-01' into its corresponding serial number.
Excel stores dates as serial numbers to perform calculations; you must apply a Date format to the cell to see it as a standard date.