You can use a constant expression as a default value, as long as it does not reference database objects. Constant expressions allow column defaults to contain entries such as the date fifteen days from today, which would be entered as

... DEFAULT ( DATEADD( day, 15, GETDATE() ) );