INTERVAL (Date)

Adds a specified number of days, weeks, months, quarters, or years to a date

Updated over a week ago

Description

The INTERVAL function allows you to perform date arithmetic by adding or subtracting a specified number of days, months, or years to a given date. This is useful for calculating future dates, project timelines, or aging calculations.

Syntax

date + INTERVAL number DAY/MONTH/YEAR

Output

date

Variables

  1. date: The starting date to which you want to add or subtract an interval.

  2. number: The numeric value representing the amount you want to add or subtract.

  3. DAY/MONTH/YEAR: Specify the time unit (day, month, or year) for the interval.

Example 1

`Start Date` + INTERVAL 7 DAY

Project

Start Date

INTERVAL

Project A

2023-09-10

September 17, 2023

Project B

2023-08-25

September 1, 2023

Project C

2023-09-01

September 8, 2023

Example 2

`Start Date` + INTERVAL 2 WEEK

Project

Start Date

INTERVAL

Project A

2023-09-10

September 10, 2023

Project B

2023-08-25

August 25, 2023

Project C

2023-09-01

September 1, 2023

Example 3

`Start Date` + INTERVAL -1 MONTH

Project

Start Date

INTERVAL

Project A

2023-09-10

August 10, 2023

Project B

2023-08-25

July 25, 2023

Project C

2023-09-01

August 1, 2023

Did this answer your question?