Excel DATE Function: How to Use It, with Examples
Turkish: TARİH

Builds a date from year, month and day values.

DATE syntax

=DATE(year, month, day)

In Turkish Excel: =TARİH(yıl; ay; gün)

ArgumentDescription
yearYear.
monthMonth (1-12).
dayDay.

DATE examples

Sample table:

AB
1StartEnd
22026-01-052026-03-20
=DATE(2026,11,12)
Result: 2026-11-12

Creates the date 12 November 2026.

Results were calculated in real Excel.

Related functions

More formula guides

More tools

About DATE Function

Builds a date from year, month and day values.

Turkish function names were taken directly from Turkish Excel, and the example results on formula pages were calculated in real Excel. Everything runs in your browser; your data is never uploaded.

How to use DATE Function

  1. Type the formulaStart typing =DATE( in a cell; Excel shows the arguments.
  2. Fill in the argumentsSeparate them with commas (semicolons in Turkish Excel).
  3. Press EnterCheck the result; you can also try it in the tester below.

Frequently asked questions

What is DATE in Turkish Excel?

In Turkish Excel, DATE is called TARİH. Turkish Excel also separates arguments with semicolons (;) instead of commas.

Which Excel versions have DATE?

DATE is available in all current Excel versions (2010 and later, Microsoft 365).