Sum of Numbers of a Rolling 6 month Period range

J

jspring0033

Hi,

I am trying to count numbers that fall between a rolling 6 month dat
period. In other words imagine the Columns with a year long date rang
with each cell containing a date. (01/01, 01/02, etc) all way to 12/31.


In the rows I have a name in each row. (50 names) If a name recieves
number for any given day I am looking for a total formula that wil
count all numbers in each cell for any given date as long as it is in
rolling 6 month period from today backwards.

If I 5 ponints and I recieved the first point on 03/06/2012 then th
total count tomorrow would be 4 since the original point i recieved i
over 6 months ago.

Any help is appreciated
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top