These docs are for v1.0. Click to read the latest docs for v1.2.

DATEADD

Creates a new date by adding an offset to a specified date.

Syntax

=DATEADD(interval, count, date)

Arguments

ArgumentTypeDescription
intervalStringThe type of interval to find the difference of
Valid intervals are:
- YEARS
- YEAR
- QUARTERS
- QUARTER
- MONTHS
- MONTH
- WEEKS
- WEEK
- DAYS
- DAY
- HOURS
- HOUR
- MINUTES
- MINUTE
- SECONDS
- SECOND
- MILLISECONDS
- MILLISECOND
countNumberThe number of intervals to add to the specified date
dateDateThe date to add intervals to

Examples

=DATEADD("YEAR", 1, DATE(2019, 01, 01))Jan 1, 2020 12:00 AM
Adds one year to the date Jan 1, 2019 12:00 AM

=DATEADD("MONTHS", 3, DATE(2019, 01, 01))Apr 1, 2019 12:00 AM
Adds three months to the date Jan 1, 2019 12:00 AM