Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Counting dates in cells
0 views
Skip to first unread message
chrspty
Aug 11, 2008, 2:28:00 AM8/11/08
to
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.
also like to count the number of times a range of dates appear in a range of
cells.
T. Valko
Aug 11, 2008, 3:03:41 AM8/11/08
to
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" <chr...@discussions.microsoft.com> wrote in message
news:0BA78D74-5CEF-4470...@microsoft.com...
David Biddulph
Aug 11, 2008, 3:10:53 AM8/11/08
to
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" <chr...@discussions.microsoft.com> wrote in message
news:0BA78D74-5CEF-4470...@microsoft.com...
0 new messages