I'm using Windows Excel 2007, if that matters, and I'm trying to have a date field update to today's date automatically only when a cell in that column gets changed.

I add new data entries per column and want "date changed" entries automatically displayed and updated in row 7 after columns A and B but only after those two header columns, and let's say if row 7 isn't blank or made blank, I want automatic date keeping to expand for a new entry.

I've looked for a solution and found the NOW() formula, but that's not quite right. I've found a few similar things, but I don't know enough about macros to change them to my desired effect.

How do I do what I've described? It may be a macro or formula.

Thanks in advance for any help.

  • You Will need to go to VBA and work with the worksheet_change procedure. You can determine the row that was changed and then change the date on that row. The NOW() won't work because it will always show the current date. – wbeard52 Nov 23 '15 at 20:31
  • if i got you right, then it is possible without vba... but i need something like a sample to really get what you want (picture or workbook) – Dirk Reichel Nov 23 '15 at 23:02

I used this:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column > 2 Then Cells("1", Target.Column) = Now()
End Sub

And it works wonderfully. Although, I foresee some unnecessary operations.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.