G1 contains function "TODAY". C8:C500 represent consecutive dates, eg C8 is 4/1/02, C9 is 4/2/02. Each day, cell will remain blank or be marked with an "x". I need a formula which will return the number of consecutive "x's" as of today. For instance, if today is April 15 (C22), and C20 is blank, while C21 and C21 contain "x's", the formula would return "2". If today's entry is blank, the formula would return "0". The concept is like a "winning streak" number in the baseball standings, for you sports fans.
Any help will be greatly appreciated.
Any help will be greatly appreciated.