Results 1 to 6 of 6

Last Update Date and Time

Threaded View

  1. #1
    Registered User
    Join Date
    06-11-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    3

    Last Update Date and Time

    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!
    Last edited by abhishekbt; 07-01-2009 at 04:27 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1