Excel DATE Function

HomeExcel Functions List (Top 100) Examples + Sample FileExcel DATE Function (Example + Sample File)


What is EXCEL DATE FUNCTION

The Excel DATE Function is listed under Microsoft Excel's Date Functions category. It returns a valid date based on the day, month, and year you input. In simple words, you need to specify all the components of date and it will it.

How to use it

To learn how to use the DATE function in Excel, you need to understand its syntax and arguments:

Syntax

DATE(year,month,day)

Arguments

  • year: A number to use as the year.
  • month: A number to use as the month.
  • day: A number to use as a day.

Notes

  • Year, Month, and Day can be negative and positive.
  • It is recommended to enter a four-digit number for the year to avoid any issue.
  • You can enter a year from 1900 to 10000. If you enter any year below than 1900 it will add that number to 1900 (For example, if you enter the year as 102 it will return the year 2002).

Example

To master DATE function we need to try it out in an example, so make sure to check out the below one:

In the below example, we have used cell references to specify the year, month, and day to create a date.

You can also insert arguments directly into the function to create a date as you can see in the below example.

And in the below example, we have used different types of arguments to see the result returned by the function.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.