# Excel DATE Function

## What is DATE function in Excel?

The DATE function is one of the Date & Time functions of Excel.

It Returns the number that represents the date in Microsoft Excel date-time code.

We can find this function in Date & Time of insert function Tab.

## How to use Date function in excel

1. Click on an empty cell (like F5).

2. Click on the fx icon (or press shift+F3).

3. In the insert function tab you will see all functions.

4. Select Date & Time category.

5. Select Date function

6. Then select ok.

7. In the function arguments Tab you will see Date function.

8. Year is a number from 1900 or 1904 (depending on the workbook’s date system) to 9999.

9. Month is a number from 1 to 12 representing the month of the year.

10. Day is a number from 1 to 31 representing the day of the month.

11. You will see the result in the formula result section.

## Examples of Date function in excel

Example 1:

### How to Creat Date in excel?

You can see examples of DATE function below:

Example 2:

### Python code for DATE function

``````import datetime

x = datetime.datetime(1990, 1, 1)

print(x.strftime(“%x”))``````

## What is the Return value  of Date function?

It Returns the number that represents the date in Microsoft Excel date-time code.

## How many arguments does Date function have?

This function has just 1 Argument.

The argument of ABS function is number.

The argument of ABS function is required and not optional.

## Which version of excel supports Date function?

This function is available for all excel versions (2003-2019)

## Date related functions

• Use DAY function to return the day of the month, a number from 1 to 31.
• Use MONTH function to return the month, a number from 1 (January) to 12 (December).
• Use YEAR function to return the year of a date, an integer in the range 1900 – 9999.
• Use YEARFRAC function to return the year fraction representing the number of whole days between start_date and end date.