Hi all
I use this formula to count date 90 day.
=INDEX($F$5:$F$12,MATCH(SUMIFS($F$5:$F$12,$H$5:$H$12,"<"&90),$I$5:$I$12,1)+1)*(INDEX($H$5:$H$12,MATCH(SUMIFS($F$5:$F$12,$H$5:$H$12,"<"&90),$I$5:$I$12,1)+1)-(INDEX($H$5:$H$12,MATCH(SUMIFS($F$5:$F$12,$H$5:$H$12,"<"&90),$I$5:$I$12,1))))/(INDEX($G$5:$G$12,MATCH(SUMIFS($F$5:$F$12,$H$5:$H$12,"<"&90),$I$5:$I$12,1)+1))+(INDEX($B$5:$B$12,MATCH(SUMIFS($F$5:$F$12,$H$5:$H$12,"<"&90),$I$5:$I$12,1)+1))
Why date in G14 cell still moving when day skip 91 or more. Can or not date stopped automatically when achieve 90 days even date in B cell and C filled.
Bookmarks