Returns the serial number of a particular date.
تعمل هذه الدالة في Google Sheets كما تعمل في Excel تمامًا — بالصياغة والوسائط نفسها.
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)النتيجة: 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.