I need an excel expert

Hi, I need to be able to tell the last date of out of stock (the last day when the value is bigger than 0. The issue is that the formula I am using is taking the first date when the value is different from zero, but if let's say the shortages start on day 5, it would take day 1