I've got =IF(Inventory_list!C2="y", Inventory_list!A2, 'formulas etc'!$D$9)
on a master sold sheet. d9 refers to a blank cell.

I've also got on the master sold sheet, =IF(A2<0, 'formulas etc'!$D$14) for
a date column. d14 refers to today's date. The d14 today's date is fine as
the initial input to a cell, but I want to datestamp the dates on the master
sold sheet so they do not update. Actually, I want to do this to the whole
column so as dates get entered periodically, they do not change from the
inital value.

What do I need to do and thanks.