Skip to content

How to Use Excel DATE Function?

Listen to this article
DATE FunctionPin
DATE Function

In general, dates are the significant ones for making any events, programs, functions, etc. Because we should decide the time of the event on a particular date. In Excel, they provided a separate DATE function that helps to create dates on the spreadsheet, so that we can easily manage large data sets. By using this function, we can perform various calculations with the date.

In this tutorial, we will guide you to know the syntax, explanation, and examples to know how to use the Excel DATE function. Get an official version of MS Excel from the following link:

Excel DATE functionPin
Excel DATE function

What is the DATE Function?

DATE is one of the built-in functions in Microsoft Excel. It comes under logical functions. We can use this function in our spreadsheet whenever we want to create a date with a specific year, month, and day.


=DATE(year, month, day)


  • year – It represents the number of the year.
  • month – Number of the month.
  • day – It is the number of the day.


  • This function helps to create a date with year, month, and day.

Return Value:

  • It helps to get a valid Excel date.

What Will DATE Function Do?

As we said earlier, the DATE function returns the valid date based on the given year, month, and day. This function is categorized as “Logical” in Excel. In order to use this function, we can give a year, month, and day in numerical values.

For instance, we have come up with an exam timetable for an academic year. For that, we have listed a set of the month, day, and year values in the table. In order to combine these values and convert them into proper dates, we can use this function.

Input valuesPin
Input values

For that, we need to apply the following formula.


Enter the formulaPin
Enter the formula

Now, click on the Enter button to execute it and get the result. 


To fill down the remaining cells, we just need to drag down the first cell. It will automatically refill the below cells one after the other.

Fill down valuesPin
Fill down values

We hope that the given scenario helped you to understand the DATE function. If still you have any confusion, then move to the below section, where we will show you a simple example.

Alternate Examples

Let’s see a simple example to know how to use the DATE function in the spreadsheet.

  • The following screenshot has shown the meetings conducted by the organization. We have given year, month, and day values in separate columns.
Meetings TablePin
Meetings Table
  • In order to get the date values, we need to apply the following formula.


Type the formulaPin
Type the formula
  • Once you have entered the formula, hit the Enter button to get the result, as shown in the below screenshot.
  • To fill the remaining cells, you need to drag down the first cell. It will automatically fill the below values in the range.
Resulted valuesPin
Resulted values

By doing so, you can easily get the specific date value in Excel. Hope it is easy for you.


We have referred to the below-mentioned articles to fully understand the purpose of the Excel DATE function. They helped us a lot. You can also check out them using the given links: DATE function[1], and DATE in Math[2].



With the help of the given scenarios and examples, you can easily understand the purpose of the DATE function in Excel and how to apply it in the spreadsheet. The screenshots help to learn it even easier. Share your suggestions in the below comment section. Thanks for visiting AawExcel. Keep Learning!!

If you want to know what people think about this DATE Function of Excel, then we suggest you look for it on the Quora interaction webpage. From where you can get to know more regarding the Excel DATE function. Here, we have provided the link to Quora’s official website.

Video Tutorial

The following video will show you how to use the Excel DATE function in the spreadsheet with proper examples.

Read Ahead:


Leave a Reply

Your email address will not be published. Required fields are marked *

Share to...