---
title: "DATE function in Excel: syntax and examples | ExcelSavvy"
description: "How to use DATE in Excel and Google Sheets: build dates from parts and do date arithmetic."
canonical_url: "https://excelsavvy.com/functions/date"
meta:
  "og:description": "How to use DATE in Excel and Google Sheets: build dates from parts and do date arithmetic."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~REFURSBmdW5jdGlvbiBpbiBFeGNlbDogc3ludGF4IGFuZCBleGFtcGxlcw%2Cdescription_~SG93IHRvIHVzZSBEQVRFIGluIEV4Y2VsIGFuZCBHb29nbGUgU2hlZXRzOiBidWlsZCBkYXRlcyBmcm9tIHBhcnRzIGFuZCBkbyBkYXRlIGFyaXRobWV0aWMu%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~REFURSh5ZWFyLCBtb250aCwgZGF5KQ%2Cp_Ii9mdW5jdGlvbnMvZGF0ZSI%2Cs_weP3lWvkI3Rz6C5k.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "DATE function in Excel: syntax and examples | ExcelSavvy"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~REFURSBmdW5jdGlvbiBpbiBFeGNlbDogc3ludGF4IGFuZCBleGFtcGxlcw%2Cdescription_~SG93IHRvIHVzZSBEQVRFIGluIEV4Y2VsIGFuZCBHb29nbGUgU2hlZXRzOiBidWlsZCBkYXRlcyBmcm9tIHBhcnRzIGFuZCBkbyBkYXRlIGFyaXRobWV0aWMu%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~REFURSh5ZWFyLCBtb250aCwgZGF5KQ%2Cp_Ii9mdW5jdGlvbnMvZGF0ZSI%2Cs_weP3lWvkI3Rz6C5k.png"
---

> Index of every page on this site: [llms.txt](https://excelsavvy.com/llms.txt)

# **The DATE function**

Builds a date from a year, month and day. Months and days outside the normal range roll over: month 14 is February next year.

=

DATE(

## **How to use DATE**

DATE builds a date from three numbers: year, month and day. It works like snapping a date together from three building blocks instead of typing it as text, so Excel knows exactly which number is the month and which is the day, whatever the regional settings.

Use it when a date arrives in pieces, such as three columns with year, month and day from another system: `**=DATE(A2,B2,C2)**`. Use it to move forward from an existing date: `**=DATE(YEAR(A2),MONTH(A2)+1,DAY(A2))**` gives the same day next month. And use it for fixed dates inside a formula, like `**=IF(A2<DATE(2024,1,1),"Before","After")**`.

The month and day may go outside their normal range. Month 14 becomes February of the next year, and day 0 is the last day of the month before, so `**=DATE(2024,3,0)**` is Feb 29, 2024. That makes date math easy, but it has a catch: Jan 31 plus one month rolls over into March. For month steps, EDATE or EOMONTH is the safer choice.

DATE returns a number, so give the cell a date format. If you need the date as text, wrap it in TEXT.

## **Syntax**

```
DATE(year, month, day)
```

<dl><dt>**year **</dt>
<dd>The year, such as 2024.</dd>
<dt>**month **</dt>
<dd>The month, 1 to 12 (other values roll over).</dd>
<dt>**day **</dt>
<dd>The day of the month.</dd></dl>

## **Examples**

B1=DATE(2024,3,15)-DATE(2024,1,1)

|  | A | B |
| --- | --- | --- |
| 1 |  | **74** |

B1=MONTH(DATE(2024,14,1))

|  | A | B |
| --- | --- | --- |
| 1 |  | **2** |

## **Common DATE mistakes**

- DATE shows a number like 45366 instead of a date

  The formula is right, but the cell is formatted as a number. Give the cell a date format and the date appears.
- DATE returns 1924 instead of 2024

  Years from 0 to 1899 get 1900 added. Write the full year, as in `**=DATE(2024,3,5)**`, or add 2000 yourself: `**=DATE(2000+A2,3,5)**`.
- A date from another system does not work in calculations

  It is probably stored as text, often left-aligned. Rebuild it with DATE from its parts. For text like 15-03-2024 in A2, use `**=DATE(RIGHT(A2,4),MID(A2,4,2),LEFT(A2,2))**`.
- Adding 30 days does not land on the same day next month

  Months have different lengths, so 30 days drifts. Use `**=EDATE(A2,1)**` for the same day next month, or `**=DATE(YEAR(A2),MONTH(A2)+1,DAY(A2))**` if the day is 28 or less.

## **Read the guide**

- [**Dates in Excel: how they work and the formulas you need**](https://excelsavvy.com/learn/excel-dates)
- [**Excel calendar 2026: build your own with week numbers and holidays**](https://excelsavvy.com/learn/excel-calendar-2026)
- [**Excel data cleaning practice: a messy file with tasks and answers**](https://excelsavvy.com/learn/excel-data-cleaning-practice)

## **Questions**

<details>

<summary>

### How do I add months to a date?

</summary>

Use =EDATE(A2,3) to add three months. Building it with DATE and MONTH(A2)+3 works too, but a day that does not exist in the new month, such as the 31st, rolls into the month after.

</details>

<details>

<summary>

### How do I get the last day of a month?

</summary>

=EOMONTH(A2,0) gives the last day of the month in A2. With DATE you can use day 0 of the next month: =DATE(2024,3,0) returns Feb 29, 2024.

</details>

<details>

<summary>

### How do I turn year, month and day columns into one date?

</summary>

Put the three cells into DATE in that order: =DATE(A2,B2,C2).

</details>

<details>

<summary>

### How do I count the days between two dates?

</summary>

Subtract them. =DATE(2024,3,15)-DATE(2024,1,1) gives 74. If the result shows as a date, change the cell format to Number.

</details>

## **Related functions**

- [**YEAR**](https://excelsavvy.com/functions/year)
- [**MONTH**](https://excelsavvy.com/functions/month)
- [**EOMONTH**](https://excelsavvy.com/functions/eomonth)
- [**TODAY**](https://excelsavvy.com/functions/today)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://excelsavvy.com/#identity","@type":"Organization","name":"ExcelSavvy","url":"https://excelsavvy.com/","logo":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/#website","@type":"WebSite","inLanguage":"en-US","name":"ExcelSavvy","url":"https://excelsavvy.com/","alternateName":["Excel Savvy","ExcelSavvy.com","PracticeExcel","Practice Excel Online"],"publisher":{"@id":"https://excelsavvy.com/#identity"},"workTranslation":[{"@id":"https://excelopgaver.dk/#website"},{"@id":"https://excelpraxis.de/#website"}]},{"@id":"https://excelsavvy.com/functions/date#webpage","dateModified":"2026-11-16","description":"How to use DATE in Excel and Google Sheets: build dates from parts and do date arithmetic.","name":"DATE function in Excel: syntax and examples","url":"https://excelsavvy.com/functions/date","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/functions/date#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/functions/date#/schema/question/1"},{"@id":"https://excelsavvy.com/functions/date#/schema/question/2"},{"@id":"https://excelsavvy.com/functions/date#/schema/question/3"},{"@id":"https://excelsavvy.com/functions/date#/schema/question/4"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/functions/date"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/functions/date#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Excel functions","item":"https://excelsavvy.com/functions","position":2},{"@type":"ListItem","name":"DATE function in Excel: syntax and examples","position":3}]},{"@id":"https://excelsavvy.com/functions/date#article","dateModified":"2026-11-16","description":"How to use DATE in Excel and Google Sheets: build dates from parts and do date arithmetic.","headline":"DATE function in Excel: syntax and examples","inLanguage":"en-US","thumbnailUrl":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~REFURSBmdW5jdGlvbiBpbiBFeGNlbDogc3ludGF4IGFuZCBleGFtcGxlcw%2Cdescription_~SG93IHRvIHVzZSBEQVRFIGluIEV4Y2VsIGFuZCBHb29nbGUgU2hlZXRzOiBidWlsZCBkYXRlcyBmcm9tIHBhcnRzIGFuZCBkbyBkYXRlIGFyaXRobWV0aWMu%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~REFURSh5ZWFyLCBtb250aCwgZGF5KQ%2Cp_Ii9mdW5jdGlvbnMvZGF0ZSI%2Cs_weP3lWvkI3Rz6C5k.png","@type":["Article","TechArticle"],"author":{"@id":"https://excelsavvy.com/#identity"},"image":{"@id":"https://excelsavvy.com/#/schema/image/1"},"isPartOf":{"@id":"https://excelsavvy.com/functions/date#webpage"},"mainEntityOfPage":{"@id":"https://excelsavvy.com/functions/date#webpage"},"publisher":{"@id":"https://excelsavvy.com/#identity"}},{"@id":"https://excelsavvy.com/functions/date#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"How do I add months to a date?","acceptedAnswer":{"@type":"Answer","text":"Use =EDATE(A2,3) to add three months. Building it with DATE and MONTH(A2)+3 works too, but a day that does not exist in the new month, such as the 31st, rolls into the month after."}},{"@id":"https://excelsavvy.com/functions/date#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"How do I get the last day of a month?","acceptedAnswer":{"@type":"Answer","text":"=EOMONTH(A2,0) gives the last day of the month in A2. With DATE you can use day 0 of the next month: =DATE(2024,3,0) returns Feb 29, 2024."}},{"@id":"https://excelsavvy.com/functions/date#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"How do I turn year, month and day columns into one date?","acceptedAnswer":{"@type":"Answer","text":"Put the three cells into DATE in that order: =DATE(A2,B2,C2)."}},{"@id":"https://excelsavvy.com/functions/date#/schema/question/4","@type":"Question","inLanguage":"en-US","name":"How do I count the days between two dates?","acceptedAnswer":{"@type":"Answer","text":"Subtract them. =DATE(2024,3,15)-DATE(2024,1,1) gives 74. If the result shows as a date, change the cell format to Number."}},{"@id":"https://excelsavvy.com/#logo","@type":"ImageObject","caption":"ExcelSavvy","contentUrl":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3","inLanguage":"en-US","url":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3"},{"@id":"https://excelsavvy.com/#/schema/image/1","@type":"ImageObject","contentUrl":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~REFURSBmdW5jdGlvbiBpbiBFeGNlbDogc3ludGF4IGFuZCBleGFtcGxlcw%2Cdescription_~SG93IHRvIHVzZSBEQVRFIGluIEV4Y2VsIGFuZCBHb29nbGUgU2hlZXRzOiBidWlsZCBkYXRlcyBmcm9tIHBhcnRzIGFuZCBkbyBkYXRlIGFyaXRobWV0aWMu%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~REFURSh5ZWFyLCBtb250aCwgZGF5KQ%2Cp_Ii9mdW5jdGlvbnMvZGF0ZSI%2Cs_weP3lWvkI3Rz6C5k.png","inLanguage":"en-US","url":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~REFURSBmdW5jdGlvbiBpbiBFeGNlbDogc3ludGF4IGFuZCBleGFtcGxlcw%2Cdescription_~SG93IHRvIHVzZSBEQVRFIGluIEV4Y2VsIGFuZCBHb29nbGUgU2hlZXRzOiBidWlsZCBkYXRlcyBmcm9tIHBhcnRzIGFuZCBkbyBkYXRlIGFyaXRobWV0aWMu%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~REFURSh5ZWFyLCBtb250aCwgZGF5KQ%2Cp_Ii9mdW5jdGlvbnMvZGF0ZSI%2Cs_weP3lWvkI3Rz6C5k.png"}]}
```

## Sitemap

See the full [sitemap](https://excelsavvy.com/sitemap.md) for all pages.
