Construct date from year, month, and day of month.
Syntax
YEAR (year ; month ; day)Syntax: DATE( Integer Year ; Integer Month ; Integer Day )
Returns: Date
Constraints: 1 <= Month <= 12; 1 <= Day <= 31
Semantics: This computes the date's serial number given Year, Month, and Day. Fractional values are truncated.
year (required) - An integer between 1583 and 9956, or 0 - 99representing the year.
month (required) - An integer between 1 and 12 representing month.
day (required) - An integer between 1 and 31 representing day of month.
Examples
Hard Code values:
...
Syntax | Result |
|---|---|
=DATE(1969 |
...
; |
...
6 |
...
; |
...
21) |
...
June |
...
21, |
...
1969 |
...
=DATE(1 |
...
; |
...
6 |
...
; |
...
21 |
...
) |
...
...
June 21, |
...
1 AD |
BYear = 1969 |
...
=DATE([BYear];[BMonth];[BDay]) |
...
June 21, 1969 |
...