# How to Use DATE Function

The DATE function is to combine the year, the month and the day to form a date.

Formula:

=DATE(year,month,day)

Explanations:

– Year is required, an integer with one to four digits that stands for the year.

– Month is required, an integer representing January to December.

– Day is required, an integer representing the day from 1 to 31.

Cautions:

Excel for Windows uses the 1900 date system, so the first date is January 1, 1900.

– Year: If between 0 and 1899 (inclusive), you need to add that value to 1900 for the year. For example, DATE(108,1,2) returns January 2, 2008 (1900+108).

– Month: If Month is greater than 12, use that value divided by 12, add divisor to the year and remainder for the month.

If Month is less than 0, use December of the year before minus the absolute value of the month.

– Day: If Day is greater than the number of days in the month, divided by the number of days, add divisor to the month and use the remainder for the day

If Day is less than 0, use the last day of the Month before minus the absolute value of the days