Converts a date stored as text into a serial number that Excel recognizes as a date.
Bu işlev, Google E-Tablolar'da Excel'deki gibi çalışır — aynı söz dizimi ve bağımsız değişkenler.
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")Sonuç: 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.