title: Automatic date update in a cell when another cell's value changes (as calculated by a formula)
body: <p>I have a formula in C2, say <code>=A2+B2</code>. Whenever C2 changes value (actual value, not formula) I want to have the present date and time updated in D2.</p>
  
  <p>I have tried a lot of VBA codes and tricks and none of them works if a formula is entered in C2. BUT if I type a value manually in C2 the date and time is updated as needed. This is of course because a real value is entered/changes - where the formula stays the same, so to speak.</p>
  
  <p><strong>Question:</strong>
  Is it possible to create a VBA code (or something else) that updates D2 when the result of the formula in C2 changes?</p>
  
  <p>If possible, I need this to be active for the cells C2:C30 (+ D2:D30 for the date+time)</p>
  
  <p>Using Excel 2010.</p>