Tuesday, June 21, 2011

How to use date formula in Excel?

DATE


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

Twitter Bird Gadget