DATE
Definition of DATE
Converts a provided year, month, and day into a date.
Sample Usage
DATE(1969,7,20)
DATE(A2,B2,C2)
Syntax
DATE(year, month, day)
year
- The year component of the date.month
- The month component of the date.day
- The day component of the date.
Notes
- Inputs to
DATE
must be numbers - if a string or a reference to a cell containing a string is provided, the#VALUE!
error will be returned. DATE
will silently recalculate numeric dates which fall outside of valid month or day ranges. For example,DATE(1969,13,1)
, which specifies the illegal month 13, will create a date of 1/1/1970. Similarly,DATE(1969,1,32)
, which specifies the non-existent 32nd day of January, will create a date of 2/1/1969.DATE
will silently truncate decimal values input into the function, e.g. a month of 12.75 will be interpreted as 12.
See Also
TO_DATE
: Converts a provided number to a date.
TIME
: Converts a provided hour, minute, and second into a time.
N
: Returns the argument provided as a number.
DATEVALUE
: Converts a provided date string in a known format to a date value.
In order to use the DATE formula, start with your edited Excellentable:
Then type in the DATE formula in the area you would like to display the outcome:
By adding the values you would like to calculate the DATE formula for, Excellentable will generate the outcome:
A
|
B
|
C
|
D
|
|
---|---|---|---|---|
1
|
||||
2
|
||||
3
|
||||
4
|
||||
5
|
||||
6
|
||||
7
|
||||
8
|
||||
9
|
||||
10
|
||||
11
|
||||
12
|
||||
13
|
||||
14
|
||||
15
|
E
|
F
|
G
|
|
---|---|---|---|
1
|
Date
2
1,775 (4,597)
7
2010
3
94,743 (245,383)
1
12
4
396 (1,026)
9
25
5
1,143 (2,960)
4
2011
6
7,916 (20,502)
53
12
7
452 (1,171)
7
25
8
701 (1,816)
5
2012
9
540 (1,399)
1
12
10
12,133 (31,424)
27
25
11
1,912 (4,950)
14
2013
12
4,509 (11,678)
2
12
13
926 (2,398)
2
25
14
15
DATE:
12/25/2011