The DATEADD function adds or subtracts a specified interval from a date value. By default, the function adds the specified number of days when the interval is not provided.
The input dates should be in MM/DD/YYYY format. References are also accepted as arguments.
DATEADD(date, count, [interval])date: The input date.count: The number of intervals to add or subtract. Positive values add intervals, and negative values subtract intervals.interval (optional): The interval type to apply. Supported values include "day", "month", and "year". If not specified, the function uses "day" by default.Returns the calculated date.
DATEADD([Open Date], 5)Adds 5 days to the Open Date value.
DATEADD([Open Date], 1, "month")Adds 1 month to the Open Date value.
