Last Update Date and Time

**abhishekbt** · 06-30-2009, 05:30 AM

I have a simple timesheet excel sheet where I keep track of all my TO DO activities. I have a columm called Start Date to keep track of when I started something. Rather than filling it up manually, I came up with the formula below and thought I was a genius.
=IF(B2<>"",NOW(),"")

But, now as luck would have it, all my rows get updated every time I save the worksheet.

My requirement is very simple. I need to track when content was added to a cell. (even a NULL check is fine). As soon as content is added to column A, the date/time should appear automatically in column B and stay there forever.

Plz help!

**abhishekbt** · 07-01-2009, 04:28 AM

Plz help!!!

**kimbal** · 07-01-2009, 06:50 AM

Hello,

I think you may do this with macro in the workbook close event
i.e. mark the last update time during workbook close
please see the attached sample

**squiggler47** · 07-01-2009, 09:39 AM

Take a look at this

http://www.excelforum.com/tips-and-t...ell-entry.html

Its similar to what you are doing!

**abhishekbt** · 07-01-2009, 11:46 PM

Sorry Kimbal, your excel didn't work on my PC. Not sure if it was a macro problem or what.

Squiggler, You rock! I couldn't get the formula working when I directly copied it from the forum page. (Yes, I changed the refrences to suit mine). But then I downloaded the sample excel and found it was working. Finally figured it out after playing around a bit.

That Sample excel has inspired me to add some more columns to my sheet!
Thanks man!

**squiggler47** · 07-02-2009, 03:51 AM

The catch point is that the formulas are dependent on 2 things :-

Iterative calculation being set to on!

and the order of the formulas must be the same (time cant be to the right or above the second True/false!