ADD_WEEK( ) Adds a specified number of weeks to a date value. Syntax ADD_WEEK(date, weeksToAdd) Arguments date The date or date expression representing the start date. weeksToAdd The number of weeks to add to the start date. If you specify a negative number, the result is as if the number is subtracted from the start date. Returns The date value that results from adding the number of weeks to the start date. Example The following example adds two weeks to each date value in the OrderDate data field: ADD_WEEK([OrderDate], 2)