Maintain date once entered into a field
 

Trying to have two columns that will capture the original date and
updated date after making a change to a row. I used this formula as a
quick test and it populates the date but if any cell is changed on the
spreadsheet the date is updated again - in cell A1 [
=IF(ISBLANK(B1),"blank",NOW()) ].

GOAL: on insert to the row - I'd like to populate both 'original date'
and 'update date' and then when changes are made to that row - just
modify the 'update date' cell.

any help is appreciated.

Maintain date once entered into a field
 

Hi
See: http://www.mcgimpsey.com/excel/timestamp.html
as a starzing point

--
Regards
Frank Kabel
Frankfurt, Germany


christian wrote:
Trying to have two columns that will capture the original date and
updated date after making a change to a row. I used this formula as a
quick test and it populates the date but if any cell is changed on
the
spreadsheet the date is updated again - in cell A1 [
=IF(ISBLANK(B1),"blank",NOW()) ].

GOAL: on insert to the row - I'd like to populate both 'original
date'
and 'update date' and then when changes are made to that row - just
modify the 'update date' cell.

any help is appreciated.