Converts a decimal date series to date data.
DECDATE(dateser, "date")
dateser |
- |
A series of decimal date values where each value represents the day of the year. |
"date" |
- |
Optional. A string, the starting date in dd/mm/yy format. Defaults to the date of the series. |
A series of date values.
W1: {10, 100, 200, 300}
W2: decdate(w1, "1-1-2030")
W2 contains the time values 1/10/30, 4/10/30, 7/19/30, 10/27/30
A decimal date value is an integer indicating the day of the year such that the value 1 represents the first day.
Only the year portion of the date string or series date is used to set the starting year.