DATE ()
This
function creates a real date by using three normal numbers typed into separate
cells.
Best view in desktop mode.
A
|
B
|
C
|
D
|
E
|
F
|
|
1
|
Day
|
Month
|
Year
|
Date
|
||
2
|
25
|
12
|
2019
|
12/25/19
|
=DATE(C2,B2,A2)
|
|
3
|
25
|
12
|
19
|
25-Dec-19
|
=DATE(C3,B3,A3)
|
|
4
|
33
|
12
|
2019
|
January 2, 2020
|
=DATE(C4,B4,A4)
|
|
5
|
||||||
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.
Shortcut Key for Formatting
Go to D2 cell, Press
Ctrl+1, and you will see new pop-up window like below:
No comments:
Post a Comment