Forum Discussion
Excel Auto Updates Stop Limit
Hi andrew165
Not sure this will solve the purpose.
Try this one =IF(TODAY()=TODAY(),"True or Insert text whatever you want to do","0")
On the same day it will show the value you want to show and from next day it will show 0
Please do let me know if it solved the purpose
Firstly, thank you for your reply.
The formula you gave did not correct the issue I'm having, I will try to clarify. I would like the Cell on the home page to feed the cell on sheet 2 which is an easy thing to do, however I am trying to have the cell on sheet 2 retain the value from the cell on the home page at a specific date and time. For instance 12/11/2020 4 P.M EST (market close) and maintain that value while the cell on the home page is updating again the next day and feeding the next cell in line.