DATE function in Google Sheets - Step-by-Step Guide

Introduction

The DATE function helps you create a date from separate year, month, and day numbers. It solves the problem of combining these parts into one date that Google Sheets can understand and use in calculations.

When you have year, month, and day in separate cells and want to combine them into one date.

When you want to create a date for a specific day to use in formulas like calculating age or days between dates.

When you need to fix dates that are split into parts after importing data.

When you want to build a date dynamically based on other cell values.

When you want to ensure the date format is consistent regardless of your spreadsheet locale.

Steps

Step 1: Click

- the cell where you want the date to appear

The cell is selected and ready for input

Step 2: Type

- the formula bar

The formula is entered in the cell

💡 Start with an equal sign (=) to tell Sheets you are entering a formula

Step 3: Enter

- the formula bar

The formula calculates and shows the date in the cell

Step 4: Type

- the formula bar

Formula example: =DATE(2024, 6, 15) creates June 15, 2024

Step 5: Use

- cell references inside DATE function

Example: =DATE(A1, B1, C1) creates a date from year in A1, month in B1, and day in C1

Before vs After

Before

Year is in cell A1 as 2024, month in B1 as 6, day in C1 as 15

After

Cell D1 shows 6/15/2024 as a date after entering =DATE(A1, B1, C1)

Settings Reference

Date format

📍 Format menu > Number > Date

Controls how the date appears in the cell

Default: Depends on your locale

Common Mistakes

Entering the date parts as text strings inside quotes, like =DATE("2024", "6", "15")

DATE expects numbers, not text, so it may give an error or wrong result

Enter numbers without quotes: =DATE(2024, 6, 15)

Using zero or negative numbers for month or day

Months and days must be positive numbers; zero or negative values cause errors

Use valid positive numbers for year, month, and day

Summary

The DATE function combines year, month, and day numbers into one date value.

Use it when you have date parts in separate cells or want to create dates dynamically.

Make sure to enter numbers without quotes and use valid positive values.