View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sunflower[_3_] Sunflower[_3_] is offline
external usenet poster
 
Posts: 1
Default count number of dates in range

In column A, various contractor names are listed. In column B, completion
dates have been entered for when their projects were completed thoughout the
year. I would like to have the next spreadsheet tab summarize the data so it
lists the number of times between 2/1/20010 and 2/28/2010 a project was
completed for "Fred."

Can you tell me what formula I should enter? Thanks