Sum of Numbers of a Rolling 6 month Period range
Hi,
I am trying to count numbers that fall between a rolling 6 month date period. In other words imagine the Columns with a year long date range 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 a number for any given day I am looking for a total formula that will count all numbers in each cell for any given date as long as it is in a rolling 6 month period from today backwards.
If I 5 ponints and I recieved the first point on 03/06/2012 then the total count tomorrow would be 4 since the original point i recieved is over 6 months ago.
Any help is appreciated!
|