I have a column of dates. I want to create a formula where it looks at that column of dates, and counts the number of cells where the date occurred in the month prior to today. Anyone know how to put that into a formula?
=sumproduct(--(isnumber(a1:a51)),--(month(a1:a51)=(month(today())-1)))
Code:=sumproduct(--(isnumber(a1:a51)),--(month(a1:a51)=(month(today())-1)))
=SUMPRODUCT(--(ISNUMBER(I17:I51)),--(ISNUMBER(H17:H51)),--(MONTH(H17:H51)=(MONTH(TODAY())-1)),--(MONTH(I17:I51)=(MONTH(TODAY())-1)))
Final Submission | Initial Start |
6/5/2014 | 6/3/2014 |
6/19/2014 | 6/13/2014 |
6/26/2014 | 6/2/2014 |
6/26/2014 | 6/2/2014 |
7/17/2014 | 6/17/2014 |
7/14/2014 | 7/14/2014 |
7/2/2014 | 7/2/2014 |
7/24/2014 | 7/2/2014 |
7/30/2014 | 7/2/2014 |
8/5/2014 | 7/29/2014 |
8/22/2014 | 8/15/2014 |
8/22/2014 | 8/13/2014 |
9/2/2014 | |
7/9/2014 | |
6/26/2014 | |
7/23/2014 | |
7/9/2014 | |
7/9/2014 | |
7/29/2014 | |
=SUMPRODUCT(--(MONTH(A1:A51)=MONTH(TODAY())-1),--(MONTH(A1:A51)=MONTH(B1:B51)))
Please note that none of these formulas will check to see if the two dates are in the same year or not.