I am trying to include a date stamp in column A which does not change after each calculation. The following formula seems to do the job until I turn the data into a table.
=IF(B2<>"",IF(A2="",NOW(),A2),"")
When the data is turned into a table, the date defaults to 01 Jan 1900 00:00
Does anyone have any suggestions how to get this to work correctly in a tbale where the formula will automatically be inserted when new data is added.
Bookmarks