Fonction Google Sheets

DATEVALUE

Converts a date stored as text into a serial number that Excel recognizes as a date.

Générer une formule avec l'IA La même fonction dans Excel

Cette fonction fonctionne de la même façon dans Google Sheets que dans Excel — même syntaxe et mêmes arguments.

Syntaxe

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.

Arguments

date_textobligatoireA string that represents a date in an Excel-recognized format.

Exemples

=DATEVALUE("2023-01-01")

Résultat : 44927

Converts the text string '2023-01-01' into its corresponding serial number.

FAQ

Why does DATEVALUE return a number instead of a date?

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.

Fonctions associées

DATE TIMEVALUE TEXT