Skip to content
# EXCEL FUNCTION – DATE

# Excel Function DATE

### Excel Function DATE Formula:

Here we mentioned “13” in the month, that is more than 12. In this case Microsoft excel will add the month and adjust the year. So adding 12+1 (i.e. December + 1 month) will be January and year would be changed to next year i.e. from 2019 to 2020

Here we mentioned “-1” in the month. In this case Microsoft excel will deduct one month from the year and will provide the output. So, adjusting (2019 – 1 month) will be November and year would be changed to previous year i.e. from 2019 to 2018

Here you may also link any of the above argument with any cells in excel to drive the formula on the basis of variables. So if your data is like below:

## Recommended Articles

## Similar Posts

### EXCEL FUNCTION – LOWER

### EXCEL FUNCTION – SUMIFS

### Calculations with Date in Excel

### EXCL FUNCTION – COUNTA

### EXCEL FUNCTION – COUNTBLANK

### EXCEL FUNCTION – SEARCH

=DATE(YEAR,MONTH,DAY)

Now while looking at above Formula, there are four parameters which are described as below:

**1. Year:** This argument is used to denote or get the year from the serial numbers. It is advisable to use the ** four digits** while using arguments for “Year”.

For Example: If you enter below formula

Syntax: =Date(2019,9,19) will give result to 09/19/2019

And If you write the above formula as below:

Syntax: =Date(19,9,19) will give result to 09/19/1919

** two Digits** in

So it is to advised that correct syntax with four digits is used to get the accurate results.

**2. Month:** Month argument is used to denote or get the month from the serial numbers. It is a numeric number starts from 1 to 12. If any negative or more than 12 numbers are used in function, then month would be adjusted from year.

For Example: If you enter below formula

Syntax: =Date(2019,9,19) will give result to 09/19/2019

So if you write this formula as below:

Syntax: =Date(2019,13,19) will give result to 01/19/2020

And if you write this formula like below:

Syntax: =Date(2019,-1,19) will give result to 11/19/2018

**3. Day:** This argument is used to denote or get the Day from the serial numbers. It is a numeric number starts from 1 to 31. If any negative or more than 31 numbers are used in function, then days would be adjusted from month and year.

For Example, if you write this formula:

Syntax: =Date(2019,9,19) will give result to 09/19/2019

So if you write this formula as:

Syntax: =Date(2019,09,32) will give result to 10/02/2019

^{th} September + 2 days) will be 2^{nd} October and output will be 10/02/2019 (i.e. 2^{nd} October 2019)

Now if you write this formula as

Syntax: =Date(2019,09,-15) will give result to 08/16/2019

^{th} August and output will be 08/16/2019 i.e. (16^{th} August 2019)

Above Formula in Cell D2 contains the Date function which is linked to Cell A2,B2,C2. So now this is driven by variable values. Hence you may use this function with multiple data points to create date. Hope you liked this article.

Please comment and share your valuable feedback or if you have any questions.

LOWER function is used for changing the format of any text or string to LOWER case.

SUMIFS function is used to get the “total sum” of values for matching criteria across range. SUMIFS Function has required and optional arguments

Calculations With Date In Excel Dates function also be used to subtract the Year, Month and Days from the existing dates. Sometimes we need to subtract specific period from the date. In case you are…

COUNTA function is used to get the total count of Any-value or Non-Blanks in range. COUNTA Function has one required and optional argument: value1, value2

COUNTBLANK function is used to get the total count of Blank or Empty cell in range.

COUNTBLANK Function has one required argument i.e. range.

SEARCH function is used to find “position of character or text” in an available cell and this function is NOT case sensitive.

## One Comment