DATE Function (Functions in Excel)
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. |
0 comments:
Post a Comment