この関数は Google スプレッドシートでも 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.