SheetFX
≡
<< Go back to all functions

DATE

The DATE function in Google Sheets is a powerful tool to convert a provided year, month, and day into a date. This function comes in handy when working with date-related data and performing calculations based on specific dates.

Function Syntax and Parameters

Syntax: DATE(year, month, day)

Parameters:

  • year: The numerical representation of the year (e.g., 2021).
  • month: The numerical representation of the month (1 = January, 2 = February, etc.).
  • day: The numerical representation of the day.

Step-by-Step Tutorial

  1. Using DATE with individual values:

    • Example: =DATE(2021, 12, 31)
    • Result: 12/31/2021

  2. Using DATE with cell references containing values:

    • Example: If cell A1 has the year, A2 has the month, and A3 has the day, then =DATE(A1, A2, A3) will return the corresponding date.

Use Cases and Scenarios

  1. Project Management: Generate project timelines based on start and end dates.
  2. Age Calculation: Calculate a person's age based on their birthdate.
  3. Expiration Dates: Determine the expiration date of a product based on the manufacturing date.

Related Functions

  • YEAR: Extracts the year from a date.
  • MONTH: Extracts the month from a date.
  • DAY: Extracts the day from a date.

Related Articles