Date in Excel

Date in Excel

This function is used to manipulate the date time.

Microsoft Excel Function

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

Why it?

This function creates a real date by using three normal numbers typed into separate cells..                                                                                 

Content Data

Day	Month	Year	Date
23	12	2010	12/23/10	=DATE(E4,D4,C4)
25	12	2010	25-Dec-10	=DATE(E5,D5,C5)
12	12	2005	December 12, 2005	=DATE(E6,D6,C6)