I am creating a spreadsheet to track stock performance. There's 5 column
Currently I'm using following formula in column D2
=IF(C2>=B2, TODAY();"")
but it will keep updating on daiy basis so i lost track of what'a the actual date of the conditioned met. is there any solution to this without using VB?
- A. StockName
- B. TargetPrice
- C. TodayPrice (update daily)
- D. TargetPriceDate
Currently I'm using following formula in column D2
=IF(C2>=B2, TODAY();"")
but it will keep updating on daiy basis so i lost track of what'a the actual date of the conditioned met. is there any solution to this without using VB?