Hi i have this formula in my cell
Please Login or Register  to view this content.
I want to stop the formula from calculating if the date in cell N1119<Today(), also the data calculated not to change to remain the last value, eg in the cell N1119 the date is 2015-10-14 and the formula gives to me the temperature 15 C the next day the formula to stop and to not update automatically, because i use an api when excel refresh automatically and if the day that i search is passed it gives to me 0 eg. if today is 2015-10-15 the formula will give 0 for response,
I use this formula in different cells.

Any help