Saturday, 3 September 2016

Excel DATE formula | EASY Excel Tutorial |


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.



No comments:

Post a Comment