How to use Excel DATE formula
|
Day
|
Month
|
Year
|
Date
|
|
|
|
|
25
|
12
|
99
|
12/25/99
|
=DATE(E4,D4,C4)
|
|
|
|
25
|
12
|
99
|
25-Dec-99
|
=DATE(E5,D5,C5)
|
|
|
|
33
|
12
|
99
|
January 2, 2000
|
=DATE(E6,D6,C6)
|
|
|
|
|
|
|
|
|
|
|
What
Does It Do?
|
|
|
|
|
|
||
This
function creates a real date by using three normal numbers typed into
separate cells.
|
|||||||
|
|
|
|
|
|
|
|
Syntax
|
|
|
|
|
|
|
|
=DATE(year,month,day)
|
|
|
|
|
|||
|
|
|
|
|
|
|
|
Formatting
|
|
|
|
|
|
|
|
The
result will normally be displayed in the dd/mm/yy format.
|
|
|
|||||
By
using the Format,Cells,Number,Date command the format can be changed.
|
|