DATEDELTA

Last update： 2022-04-04

1. Extracted data

1）Overview

Syntax	DATEDELTA(date,deltadays)	Return a deltadays after date.
Parameter1	date	In addition to text and date types, date also supports the 1900 series number, for example, 35796 is 1998-01-01.
Parameter2	deltaDays	It could be positive, negative, zero.

2）Precaution

Supports two parameters, the first a date or text type parameter and the second a numeric value

3）Example

Formula	Result	Remark
DATEDELTA("2008-08-08",-10)	2008-07-29
DATEDELTA("2008-08-08",10)	2008-08-18
DATEDELTA(35796,10)	1998-01-11

2. Real-time data

1）Overview

Syntax	DATEDELTA(date,deltadays)	Return a deltadays after date.
Parameter1	date	Support only text and date types.
Parameter2	deltadays	It could be positive, negative, zero.

2）Precaution

Supports two parameters, the first of which is a date or text type and the second of a numeric type.

3）Example

Formula	Result	Remark
DATEDELTA("2008-08-08",-10)	2008-07-29
DATEDELTA("2008-08-08",10)	2008-08-18

Previous

Next

Helpful
Not helpful
Only read

中文（简体）中文（繁體）日本語

English

滑鼠選中內容，快速回饋問題

滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。

不再提示

10s後關閉

Get
Help

*Problem Type

Incomprehensible Content Incorrect Content Incomplete Procedure Other Content Problems Doc Page Function Feedback

Cannot be empty

Problem Description

0/1000

Cannot be empty

Submitted successfully

Network busy