| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting dates in cells
How do I count how many times a date appears in a range of cells? I would
also like to count the number of times a range of dates appear in a range of cells. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting dates in cells
Try these:
A1 = 1/1/2008 B1 = 1/15/2008 Count how many times 1/1/2008 appears in the range D1:D10 - =COUNTIF(D1:D10,A1) Count how many dates in the range D1:D10 are between 1/1/2008 and 1/15/2008 (inclusive): =COUNTIF(D1:D10,"="&A1)-COUNTIF(D1:D10,""&B1) -- Biff Microsoft Excel MVP "chrspty" wrote in message ... How do I count how many times a date appears in a range of cells? I would also like to count the number of times a range of dates appear in a range of cells. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting dates in cells
1 =COUNTIF(A1:A21,DATE(2008,8,1))
2 =COUNTIF(A1:A21,"="&DATE(2008,8,1))-COUNTIF(A1:A21,""&DATE(2008,8,31)) -- David Biddulph "chrspty" wrote in message ... How do I count how many times a date appears in a range of cells? I would also like to count the number of times a range of dates appear in a range of cells. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting days comparing 2 dates excluding empty cells | Excel Worksheet Functions | |||
| counting cells containing certain ranges of dates | Excel Worksheet Functions | |||
| counting valid dates in a range of cells | Excel Worksheet Functions | |||
| counting occasions dates occur between 2 dates | New Users to Excel | |||
| Counting the number cells between two dates | Excel Discussion (Misc queries) | |||
Linear Mode
