I have a worksheet that I am trying to create a formula for. What I want is
once a certain cell has text in it, the next cell populates with the date the
first cell was entered. I figured that part out by using a combination of
the "IF" formula and the "NOW" formula. But after that function works, I
dont want that date to change, because this worksheet will be continually
working in. When I open the worksheet tomorrow, tomorrow's date will now
show up in the "date cell" and I want to keep it as the date the text was
entered, not "NOW" or "TODAY".

Thanks,
Chris