Countif and dates
Put some dates in A1 thru A30:
11/13/2008
11/10/2007
9/2/2007
3/17/2008
5/1/2007
7/9/2008
1/7/2007
10/5/2008
8/27/2007
11/10/2007
6/5/2007
3/21/2007
3/27/2008
5/17/2007
5/2/2008
3/23/2007
10/18/2008
4/6/2008
2/14/2007
12/5/2008
7/3/2007
4/26/2007
9/21/2008
8/23/2008
8/25/2007
6/7/2007
3/3/2007
8/10/2008
8/12/2007
9/4/2008
then
=SUMPRODUCT(--(YEAR(A1:A30)=2007),--(MONTH(A1:A30)=5))
will give you the count for May 2007
--
Gary''s Student - gsnu200769
"Tom" wrote:
I need to count datess in a column if they occur in a specific month and year.
Can anyone help?
--
Tom
|