.

DATE Function Dictionary

Function Dictionary Function Examples Function Categories

DATE        
 
   
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.

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download