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
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 |
Download the Excel Formulas Ebook for a fast and simple guide to the most useful Excel formulas.
Follow us on
