Thread: Count Dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Matthew Tyrus Matthew Tyrus is offline
external usenet poster
 
Posts: 1
Default Count Dates

I have a list of dates in the following format MM/DD/YYYY.

1/11/2008
1/12/2008
1/30/2008
1/10/2008
1/10/2008
1/10/2008
1/12/2008
1/6/2008

I want to know how many times a date falls in-between a certain week. For
instance, countif(range,"=1/1/2008","<=1/6/2008"). It should be 1.

Any help?