Extracted Data
1. Overview
Syntax | DATEDELTA(Date,Deltadays) | Returns the date that is deltadays after the input date. |
Parameter 1 | Date | Besides the text and date types, the Date parameter also be of the serial number type of the 1900 date system. For example, the serial number 35796 represents 1998-01-01. |
Parameter 2 | DeltaDays | The parameter value can be positive, negative, or zero. |
2. Notes
The function supports two parameters, with the first being a date or text-type parameter, and the second being a numeric parameter.
3. Example
| Formula | Result | Note |
|---|---|---|
DATEDELTA("2008-08-08",-10) | 2008-07-29 | |
DATEDELTA("2008-08-08",10) | 2008-08-18 | |
DATEDELTA(35796,10) | 1998-01-11 | |
DATEDELTA(TODAY(),-1) | Date of Yesterday |
Real-Time Data
1. Overview
Syntax | DATEDELTA(Date,Deltadays) | Returns the date that is deltadays after the input date. |
Parameter 1 | Date | The Date parameter can only be of the text or date type. |
Parameter 2 | Deltadays | The parameter value can be positive, negative, or zero. |
2. Notes
The function supports two parameters, with the first being a date or text-type parameter, and the second being a numeric parameter.
3. Example
| Formula | Result | Note |
|---|---|---|
DATEDELTA("2008-08-08",-10) | 2008-07-29 | |
DATEDELTA("2008-08-08",10) | 2008-08-18 |
