| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count occurance of a month in a column of dates? | Excel Worksheet Functions | |||
| Count number of cells of a particular month in a column of dates | Excel Discussion (Misc queries) | |||
| Count if date is between two dates and value in another column equ | Excel Worksheet Functions | |||
| count no. of dates in a column that falls on certain month & year | Excel Worksheet Functions | |||
| Count cells in a column that contain dates | New Users to Excel | |||
Threaded Mode
