Use Of Date
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.
| |||||
मेरी कहानियाँ Index प्रतिदिन सुविचार
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें