Microsoft Office excel 2007 home & stude...

Hello,

Does anyone know of formula in excel that I

can use to sum the total number of cells that

occur last week, last month, etc? Here is what

my chart looks like

Dated Project Initiated:

5/5/10

5/5/10

5/9/10

5/15/10

6/1/10I would like create a graph that has the sum of

projects initiated "last week" and another one

that has the sum of "Last Month"...and I would

like it to change weekly/monthly just like

conditional formation does....help? Anyone?

THANKS!!

Let's say your dates are in A1:A5. In 2 cells someplace else (you can hide the columns later) enter these formulas.

For the purpose of this example, I'm going to assume you used B1 and C1.

B1: =WEEKNUM(A1) and drag it down to B5

C1: =MONTH(A1) and drag it down to C5

To count dates from last week and last month, use these:

=COUNTIF(B1:B5,WEEKNUM(TODAY())-1)

=COUNTIF(C1:C5,MONTH(TODAY())-1)

That worked like a charm! Thank you so much :)

Anytime!

Ask Your Question

Weekly Poll

Do you think Microsoft's new Surface Go will be a hit?

Discuss in The Lounge

Poll History