|Dates can be added just like numbers. Add 1, you've added a day; add 14, you've added 2 weeks.|
An IF statement can perform a calculation IF the logical_test argument is TRUE:
If B1 is equal to nothing, return nothing, otherwise return B1+14.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.