DATE

Posted on 22-01-2020 , by: admin , in , 0 Comments

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.

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)

Leave a comment