Counting dates in cells

C

chrspty

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.
 
T

T. Valko

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting number of times name occurs between two dates 2
Counting cells in a selectable date range 0
Count the times a specific character appears in a cell 3
Counting 2
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
counting the occurrence of specific text within a date range 4
count text occurance in range 3
Count IF 1

Top