View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Doc77 Doc77 is offline
external usenet poster
 
Posts: 2
Default Increment and replace a cell value

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!!