Excel Date Function

May 12, 2015 Excel Formulas No comments

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.

Subscribe to: Post Comments ( Atom )