Auto populated "frozen" date based on cell value.

Hey guys, I've been working on a worksheet and just realized that my Today() function changes daily.. I've been researching and realized that the only way to make it a fixed date that wont change is by using VBA. Hopefully you can help!?

I have column L:L set up with a drop down list, I want P:P to auto populate a fixed date when the user selects "Complete" in L:L.

For example, if the user selects complete in $L7 then $P7 should populate today's date. The key is that the date doesn't change anymore. I need the dates fixed for filtering and other formula purposes.

Thanks in advanced!

Ok, sorry about that. Make's sense to attach the file. I made a sample copy to avoid the size of the file.

I was planning on just modifying the code to work for the other cells. But now that you have the file here's how I wanted it to work:

When the user enters "Complete" in $L7 then the date should populate in $P7, the same go's for the others if $M7 = "complete" then $Q7 = date, if $N7 = "Complete" then $R7 = date.

The only one that ends up being different is $O7. I want to capture the date that the a new line is entered. So it would be: if $C7 <> "" then $O7 = date.

The key is that the dates stay fixed or frozen and don't change day by day, and it should work through the entire column O:O, P:P, Q:Q, R:R

Looks like it works! I'll enter a sample order and check it tomorrow to make sure the date stays fixed. Thanks for the help!!

Actually, im seeing that if I enter something in column C then I get a date on column O..

It should be: if i enter any text in column D then the date populates in columns P.

I tried playing around with the code you gave me but I cant figure it out.

Also,
If column O = "Complete" then column S should populate the date also.

Very odd. The first time I used your code it wasn't working and now that I tried it again it worked. lol I must have changed something without realizing. Thanks for the help!!!