How to stop "today" function from changing the date every day in excel

Hi,


Thanks in advance for you all


I've been looking and searching for a solution to my problem for an excel formula from the last week
but i did not find anything , I'm not that good in VB so I didn't know how to use the code ,


please please please pleas I need help



I have an excel sheet to track the customer Issues in my work


if the Issue is closed , I enter the word "closed" in cell "I7" and so on to cell "I29"
then the date will show in cell "K7" and so on in cell "K29"


and if the Issue is still open, I enter the word "open" in cell "I7" and so on to cell "I29"
then the word "pending" will show in cell "K7" and so on in cell "K29"


And if nothing entered in cell "I7" and so on to cell "I29" , nothing will show in cell "K7" and so on to cell "K29".


I am using this formula on my work sheet in cell ( K7 ) , and I have 13 sheets for each month in this workbook
and i dragged the formula till cell ( K29 )
=IF(I7="closed",today(),IF(I7="open","pending",""))


The problem is that when I open my sheet the next day all the entry dates change to today, I need the previous day entrees to stay the same and only the new entry to show today's date.

PLEASE HELP ...

Thanks for your quick reply , but it did not work when I enter "closed" , nothing shows in cell " K7"
the "pending" part is working

It worked ... ,thank you, thank you, thank you ,thank you ,thank you ,

you are a life saver

thank you ,thank you ,thank you

OK , I'll do that

and Thanks again