Hi,

I have a table with dates and respective stock prices.
Now i'm trying to check if - during a certain time period - the stock price has been below a certain value. Since I will have to do the same thing for more than 1000 values in different time periods, I can't do it manually. Any idea how to do this in a spreasheet without vba? If not, then by vba?

Sheet looks as following:

A1 Starting date of period
B1 Ending date of period
C1 Barrier value (Value that needs to be checked)
A2 - A366 Dates (2007)
B2 - B366 Stock prices (2007)