How to stop automated date from changing everyday

Good Day all that read this!!

I have a spreadsheet that i enter monthly maintence into. I use a drop down menu to select yes or no if the task was completed. If you select yes, the next cell enters the date automatically, however when i come back the next time the automatic date updates to the current date. Can someone please tell me how fix it so that once the date is populated it cannot change.

I would really appreciate it if someone could help me with this
Thanks a million

Steve

Originally Posted by protonLeah

Requires a macro; however, no workbook attached...

What Do you mean no workbook attached?

Ok I get it now I have attached it here thanks

It doesn't need a macro.

However, it does need a circular reference in which you'll need to enable iterative calculation or else excel will go on a endless loop, cause a black hole and suck you and your family inside for eternity.

Click on File and go to options. From there click on formulas fill the check box next to Enable iterative calculations.

then this code should work for your first line item. =IF(D7="yes",IF(E7="",TODAY(),E7),"")

I knew about iterative calculation and had a formula that someone else had given me but i couldn't get it to work. Thanks alot this seems to be working just fine.

You're welcome. I had the same issue on an old workbook where I wanted a timestamp that didnt update everytime i opened it. I feel your pain.