# 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 likeDated Project Initiated:5/5/105/5/105/9/105/15/106/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!!

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

#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 B5C1: =MONTH(A1) and drag it down to C5To 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