DATEDELTA

Last update：December 19, 2024

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

Previous：DATEDIF - Date Difference

Next：WEEKDATE - The Date of the Specified Week

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