I am trying to get a cell (B1) -- a date -- to increment by 14 if cell (A1)
="Yes".

The bigger picture is that I have many tasks that require status updates. I
want to use column A to reference another worksheet to determine if an update
has been received. If the update has been received then A(x) will become a
"Yes". If A(x) is "Yes" the Due Date in cell B(x) will increase by 14-days
and return that date value.

Ideally, I would like the equation for B(x) to increment by 14 and cause
A(x) to be returned to "".

Is this possible in Excel 2003???

Thanks!!