Formula to sum dates occurring last week...

Microsoft Office excel 2007 home & stude...
June 8, 2010 at 13:49:35
Specs: Windows Vista
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/10

I 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!!



See More: Formula to sum dates occurring last week...

Report •


#1
June 8, 2010 at 15:41:54
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)


Report •

#2
June 9, 2010 at 16:04:20
That worked like a charm! Thank you so much :)

Report •

#3
June 9, 2010 at 19:15:42
Anytime!

Report •
Related Solutions


Ask Question