Counting number of dates

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,
I need to be able to count how many of appts in a range of dates within a certain month: example --how many appts between 11/1/9 and 11/30/9. What would be the formula for the countif statement?

2 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
Post a small examply. the column entries may be divided by a slash so that the entreis are clear.
COLUMN A
2/3/2009
3/3/2009
4/2/2009
4/3/2009
4/5/2009
=COUNTIF(A1:A12,">=4/1/2009, <=4/30/2009")

This is the formula that I tried and got 0 entries. Formated column to date and changed the cell that I put the formula in to general format.
I don't know if I should us another formula or function, any suggestions?
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
your data is like this
date
2/3/2009
3/3/2009
4/2/2009
4/3/2009
4/5/2009

in column c (leave column B blank) type like this
MONTH
2
3
4

now in D2 copy this formula
==COUNT(IF(MONTH($A$2:$A$6)=C2,$A$2:$A$6))

invoke this formula with CONTRL+SHIFT+ENTER

now copy D2 to D3 and D4

the result in column D wil be
number
1
1
3

if there are more rows modify column C and the formula in D2 and copy down

if there are more rows and dates modify correspondingly

POST CONFIRMATION WHETHER IT IS OK