Excel > Functions

DATE Function

The Excel DATE function returns the sequential serial number for the specified date and formats the result as a date.

The syntax for the DATE function is:

=DATE(year,month,day)

Argument

Purpose

Year

The year of the specified date and can be entered using up to four digits

Month

A positive or negative number representing the month of the year from 1 - 12. Can be used to add or subtract months to and from a date

Day

A positive or negative number representing the day of the month from 1 - 31

The DATE function is most useful when the year, month and day arguments are formulas.

Examples of the DATE function in use can be found below

Data to be used for the DATE function

Function

Result

=DATE(C2,B2,A2)

20/03/2010

=DATE(C2,B2,A2-10)

10/03/2010

=DATE(C2,B2+6,A2)

20/09/2010

Follow us on

Facebook  Twitter  You Tube 

Other Date & Time Functions

Excel 2010 Superhero Course