Countif on multiple dates
This may work for you:
Assuming your dates are in Cells A1:A20 with the heading "Dates" in A1.
B1: Dates
B2: 12/9/05
B3: 12/10/05
B4: 12/11/05
C1: =DCOUNT(A1:A20,"Date",B1:B4)
Does that help?
***********
Regards,
Ron
"Jim" wrote:
I would like to know how I can write a countif to count the number of times
dates are entered into a column and add those dates together. For example I
would like to count the number of times that 12/9/05, 12/10/05, and 12/11/05
appear in a column that shows multiple dates. Thanks for the help.
12/9/05
12/10/05
12/13/05
12/22/05
12/10/05
12/30/05
12/9/05
12/10/05
12/13/05
12/22/05
12/10/05
12/30/05
12/9/05
12/10/05
12/13/05
12/22/05
12/10/05
12/30/05
|