Hi,

I am working on a work sheet and need to enable cells so when someone enters some text into a cell. Another cell records the current date.

Atm I have this formula.

=IF(ISTEXT(D11),TODAY(),"")

This works to a degree but the cell changes the date to be the current date when ever the Excel file is opened. I need this date to stay fixed to the day the text in Cell D11 is added.

Any suggestions?