I have the following formula on my worksheet that I was going to use to
record a date when a stock level is reached:
IF($I3>=$H3,TODAY(),"INCOMPLETE")
Of course its not gunna work because after all 'tomorrows another day' so my
formula is going to return a different date.
What I need is the exact day that I3 =H3 to be noted so I guess I need an
event right?
I also need it to work on a range of cells. Not sure how to go about this.
GK
Bookmarks