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(1999, 1, 1),1)

=adddays(Section1.A1,14)
=adddays(A,-1)
=adddays(B3, C1+3)

=adddays(datetime(1990,1,1,14,30),3)

=adddays(UTC(2017,1,9,19,50),1.5)

=adddays(datetime(C3),0.5)