You'd want to use getdate() to find the current day and date and use that in a formula with dateadd.