See my attached spreadsheet. I am trying to get start dates and end dates based upon rates.
The first start date is really simple, I just use A2.
In F2 should return the last date from A2:A27 where the rate is I2
In E3 The I would like to return the first date in A2:A27 where the rate is G3
and so on. If the rate is 0 then the date can be blank or 1/1/1900
Can someone please help?
Thank you!
Bookmarks