Date Function

The Microsoft Excel DATE function returns the serial date value for a date.

The DATA function is a built -in function in Excel that a categorized as a Date/Time Function. It can be used as a worksheet function in Excel. As a worksheet function, the DATE function can be entered as part of formula in a cell of a worksheet.

Syntax

The syntax for the DATE function in Microsoft Excel is:

Date( Year, month, day)

Parameters or Arguments

Year
      A number that a between one and four digits that represents the year

Month
     A number representing the month value. If the month value is grater that 12, then every   12 months will add 1 year to the year value. This meas that DATE(2016,13,4) is equal to DATE (2017,1,4)

Day
    A number representing the day value. If the day value is grater that the number of days in the month specified, then the appropriate number of months will be added to the month value.


Note

•  If the year is between 0 and 1899, the year value is added to 1900 to determine the year
• If the year between 1900 and 9999, the DATE function uses the year value as the year
• If the year is grater that 9999, the DATA function will return the #NUM error.
• A serial data is how excel stores dates internally and it represents the number of days since January 1, 1900