I have several years of daily rainfall data and I'm trying to figure out the likelihood of having a sufficiently dry day to do agricultural work.
In one column I have rainfall in inches, in the next column I have how many days it will take soil to dry after that much rain, in the next column I would like it to say wheter or not the soil is dry on that day. Obviously if it rained that day, then the soil isn't dry. But if yesterday ways a day when it rained it won't be dry either, nor if 4-drying days worth of rain fell two days ago...
So say it rains on Day A and it will take n days to dry after that, and Day B is sometime after that, is there a way to have excel return a T/F indicating whether there are n rain free days (0 values in the rainfall column) between Day B and Day A?
Or perhaps there's an easier (or existant) way to do this?
Bookmarks