percentage something is done based on date nfletch 12/31/2008 2:50:11 PM I want to track the number of times I do something each day in excel and get a running percentage of the success rate. Easy example would be tracking what percentage of days I work out in the new year. I have the dates set up for the year, and have columns for things I want to track success rate on, but am lost after that. Any help is greatly appreciated. -- Nathan

Re: percentage something is done based on date JE McGimpsey <jemcgimpsey[ at ]mvps.org> 12/31/2008 3:31:07 PM One way: B366: = COUNTA(B1:B365)/(TODAY()-DATE(2009,1,0)) In article <2DBED77E-9F6A-4325-8DFE-44AEDEB61E61[ at ]microsoft.com>, nfletch <nfletch[ at ]discussions.microsoft.com> wrote: [Quoted Text] > I want to track the number of times I do something each day in excel and get > a running percentage of the success rate. Easy example would be tracking > what percentage of days I work out in the new year. I have the dates set up > for the year, and have columns for things I want to track success rate on, > but am lost after that. > > Any help is greatly appreciated.