Here is more specifics:
I am working with financial data by period and the periods fall across
multiple months. From the example below I will need to sum the data from
another cell with the data in this row but as periods are completed I will
need to remove these cells. For example my first calculation will include all
13 periods plus the one additional cell. But in 4 weeks I will no longer need
A1.

A1 B1 C1 D1 E1 F1 G1 H1 I1 J1 K1 L1 M1
$1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1


"Gary''s Student" wrote:

Here is just an example:

10/10/08 27
9/4/08 36
11/16/08 50
9/28/08 67
11/20/08 56
10/25/08 46
11/1/08 63
10/12/08 23
11/22/08 62
12/2/08 36
11/27/08 59
10/15/08 77
9/15/08 63
11/15/08 21
10/16/08 78
10/9/08 45
12/5/08 34
11/7/08 26
11/11/08 64
9/2/08 74
9/19/08 57
9/4/08 36
10/8/08 25
10/14/08 55
11/8/08 24
10/5/08 32
10/6/08 74
10/7/08 65
10/15/08 52
12/3/08 22

Notice the data is not even sorted. We want the sum of the November data
only.

=SUMPRODUCT((MONTH(A1:A30)=11)*(B1:B30))

To get October data use 10 in place of 11
--
Gary''s Student - gsnu200820


"Kesbutler" wrote:

I need to create a formula based on date. I need to creat a calcualte to
include other cells only if they meet certain date requirements. The cells
will meet the requirements a certain period of time then will need to be
removed from the formula. I am trying t automate the worksheet so I don't
have to update it once a month to exclude the previous 4 weeks. How can I do
this?