View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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