View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CJP CJP is offline
external usenet poster
 
Posts: 2
Default count dates in a column

Hi,

This seems a simple problem, but I'm really an Excel novice. I have a list
of animal IDs in Column A with their pregnancy due dates in Column H. I need
to know how many animals are due within a specific date range, for example:
from 1 Jan 08 up to and including 17 Jan 08.

Column A Column H
219 1 Jan 08
222 1 Jan 08
334 14 Jan 08
267 17 Jan 08
144 21 Jan 08
008 21 Jan 08
456 27 Jan 08
298 2 Feb 08 ................ and so on.