AddDays

Description of formula:
Adds a specified number of days to the date.
Syntax:
ADDDAYS(date|datetime|utc, number)
Parameters:
date (Date)
A chosen date to which days can be added.
datetime (DateTime)
A chosen date with time to which days can be added.
utc (UTC)
A chosen date with time in UTC format to which days can be added.
number (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)
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk