Returns the serial number of a particular date.
Cette fonction fonctionne de la même façon dans Google Sheets que dans Excel — même syntaxe et mêmes arguments.
DATE(year, month, day)The DATE function creates a valid date value from individual year, month, and day components. It is particularly useful when date components are stored in separate cells or generated by other formulas.
=DATE(2023, 12, 25)Résultat : 2023-12-25
Returns the date for December 25, 2023.
The function adds that number of months to the first month of the specified year.