How to stop today function date changing every day in Excel

Closed
Haneen H Posts 4 Registration date Tuesday December 17, 2013 Status Member Last seen December 18, 2013 - Updated on Dec 30, 2018 at 04:39 AM
Klaas86 Posts 1 Registration date Monday August 29, 2016 Status Member Last seen August 29, 2016 - Aug 29, 2016 at 08:52 AM
Hi,

I am using this formula on my work sheet in cell (M7), and I have 13 sheets for each month in this workbook and I dragged the formula till cell (M29)

=IF(K7="closed",TODAY(),IF(K7="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.

I am not professional in vb with excel .

Please help!

5 replies

Haneen H Posts 4 Registration date Tuesday December 17, 2013 Status Member Last seen December 18, 2013
Updated on Dec 30, 2018 at 04:55 AM
Hey everyone!

Thanks a lot for all the suggestions! Here is what I think I should conclude with:

I think it worked, but all the formulas I added to the cells are gone.
  • If I enter "open" in cell ( K7 ) the word "pending" will appear in cell ( M7 ).
  • If I enter "closed" in cell ( K7 ) the date of today will appear in cell ( M7 ).
  • If nothing entered in cell ( K7 ) nothing will appear in cell (M7 )
  • And so on to the rest of the cells .
  • This is the formula I was using :


=IF(K7="closed",TODAY(),IF(K7="open","pending",""))


It worked for me. Hope, it will work for rest of you also!
18