DATEADD

Returns a date a specified number of days, months or years before or after a given date.

Syntax: DATEADD(date, interval , interval_type)

• interval_type can take values 'D', 'DAY', 'M', 'MONTH', 'Y', 'YEAR'

Example: DATEADD ( DATE ( 2024 , 1 , 31 ) , 5 , 'M' ) Output: 2024-07-01

Example: MONTH ( DATEADD ( DATE ( 2023 , 1 , 1 ), 1 , 'M' ) ) Output: 2

Example: DAY ( DATEADD ( DATE ( 2023 , 1 , 1 ), 1 , 'M' ) ) Output: 1

FAQ

How can I add a number (days/weeks/years) to a date within a formula?

You can use the DATEADD function to accomplish this. For example, to add 3 months to April 3rd, 2025, the formula would be: DATEADD(DATE(2025, 4, 3), 3, 'M'). The output will be 2025-07-04.