In my worksheet, I have the following formula in cell BA2 =IF(AZ2="YES",TODAY(),"*")

It's obvious that once I acheive a result in cell AZ2 it returns "YES" to that cell. What I want is for cell BA2 to return the date that the "YES" result in AZ2 happened. As I have it now, the current date is diplayed in cell BA2 every time I open the workbook.

I'm fairly new to excel and I'm sure that there is a way to do this but it is beyond my feeble capabilties. BTW, I am running excel 2000.

Thanks for your help.

tsteffes