How to use date Function in Excel | Date Function Examples

Vikash Kumar

Description Of Date Function in Excel

Excel's Date function is built to create a DATE for three separate values. (Day, month, Year). If you have three separate values as 5 for the day, 4 for the month and 2017 for the year, you can easily create a date from these using DATE function.

Technical Details Of DATE Function In Excel.

Syntex:- =DATE(year,month,day)

The DATE function syntax has the following arguments:- 

  1. Year:- Argument type Required. The value of the year argument can include one to four digits. But Use four digits for the year argument to get flawless results. For example, "09" could mean "1909" or "2009."
  2. Month:- Argument type Required. The month is a positive or negative integer representing the month of the year from 1 to 12. Use 1 for January 2 for February and 12 for December. If the value of month is greater the 12, month adds that the number of months to the first month in the year specified. For example, DATE(2010,15,2) returns the serial number representing March 2, 2011. And if the month is less than 1 (negative), month subtracts the magnitude of that number of months, plus 1, from the first month in the year specified. For example, DATE(2010,-3,2) returns the serial number representing September 2, 2009.
  3. Day:-Argument type Required. The Day is a positive or negative integer representing the Days of the months from 1 to 31.
Note: Excel stores dates as sequential serial numbers so that they can be used in calculations. Its starts from January 1, 1900 and its serial number is 1, and serial number for January 1, 1901  will be 366 because it is 365 days after January 1, 1900.


DATE Function Example

Syntex:- =DATE(year,month,day)
Let's Assume the values for the arguments are as following.
Year:- 2013; Month- February; Day:- 23
Then the Date will be = Date(2013,2,23)
                      Answer =23/02/2013
See the image below for better understanding
Date Function in excel


Most commonly used Excel formulas.

How to use Vlookup in Excel.
How to import data from the web into Excel.
How To Make Shared Excel File And Allow To Edit By Multiple Users at one time.

Thanks For reading, I hope you got your problem. Please like and share this article on facebook if you found this useful. You can also comment your queries for fast response.

0 Comments