Tracking Document Log

I want to track document log where I want to get Auto update of Status as “OPEN” or “CLOSED” by inserting document submission date and document response date.

  1. I want Answer as a text “OPEN ” in Cell D5 if I insert date of doc submission in E5.
  2. If I insert answer date of doc submittal in Cell F5 then Status in D5 should change automatically as a text “CLOSED”.
  3. Again if I put resubmission (Rev-1) date in Cell I5 then Status in C5 should automatically change again to”OPEN”
  4. And when I insert answer date for doc resubmission (rev-1) date in Cell J5 then result in C5 should change to “CLOSED”
  5. And again if I put resubmission (Rev-2) date in Cell M5 then Status in C5 should automatically change again to”OPEN”
  6. And when I insert answer date for doc resubmission (rev-1) date in Cell N5 then result in C5 should change to “CLOSED”

By: Zahid

Leave a Reply

Your email address will not be published. Required fields are marked *