View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hlpmelrn hlpmelrn is offline
external usenet poster
 
Posts: 3
Default How do I put a date range in the criteria of a countif formula?

=COUNTIF('Local Annual Sales'!B4:B19,"=38991") this works to show all
months creater then Oct 2006 how do I limit it to =38991 <=39022 Oct
31, 2006?????