AddDays

Description of formula: 
Adds a specified number of days to the date.
Syntax:
ADDDAYS(date|datetime|utc, number)

Parameters:

date(type:Date)
A chosen date to which days can be added.
datetime(typ:DateTime)
A chosen date with time to which days can be added.
utc(type:UTC)
A chosen date with time in UTC format to which days can be added.
number(type:Number)
A number of whole and fractional days. (For Date type only whole parts will be taken into consideration).

Returned type:

Date | DateTime | DateTime(UTC)

Examples:
=adddays(date(2026, 1, 1),1)
=adddays(Section1.A1,14)
=adddays(A,-1)
=adddays(B3, C1+3)
=adddays(datetime(2026,1,1,14,30,00),3)
=adddays(UTC(2023,1,9,19,50,00),1.5)
=adddays(datetime(C3),0.5)
 

Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk