View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marc Shaw Marc Shaw is offline
external usenet poster
 
Posts: 7
Default Counting if between date range

I have a column of dates such as 8/5/06, I would like to create a formula
that counts the number of dates for a particular month. For example, if the
column reads as such:
9/13/06
8/28/06
9/20/06
9/20/06
8/20/06
9/22/06
9/22/06

I would like the formula to tell me that there are 2 for the month of
August. Then I could also set up another similar formular to tell me that
there are 5 for the month of September


--
Thanks,
Marc Shaw