Penny,

For future reference, G and H represent columns; not rows.
The formula contains the NOW() function which returns exactly that each time
the worksheet is recalculated. So each time an entry is made anywhere on the
worksheet and assuming the worksheet is set to automatic calculation, all of
the formulae will display the current time.
To record the time that a particular cell is updated will likely require VBA
code.
Try posting your question in the "Excel-Programming" Group.

Best wishes,
Dave


"Penny Miller" wrote in message
...
I have a worksheet that has a formula in all cells in row H that says if
there is a comment in row G then put the current date/time in H(current
cell). My formula looks like the following in H5;

=IF(ISBLANK(G5),"",NOW())

The problem is that if I enter a comment in any cell in row G it updates
all of my dates in row H.

Using Excel 2007