How Do I Use The Date Function To Create A Date From Separate Year, Month, And Day Values?

by

The DATE function in Google Sheets allows you to create a date by combining separate year, month, and day values. This can be useful when you have these values stored in different cells and want to create a date from them.

Here’s how to use the DATE function:

  1. In the cell where you want to display the result of the DATE function, enter the formula: =DATE(year, month, day)
  2. Replace “year” with the year value. You can use a cell reference or a number for this argument.
  3. Replace “month” with the month value. You can use a cell reference or a number for this argument.
  4. Replace “day” with the day value. You can use a cell reference or a number for this argument.

Here’s an example of how to use the DATE function:

=DATE(A1, B1, C1)

This formula creates a date using the year value in cell A1, the month value in cell B1, and the day value in cell C1.

I hope this helps! Let me know if you have any questions.