# Counting number of dates

Closed
april - Dec 4, 2009 at 03:40 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 6, 2009 at 09:09 PM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Dec 4, 2009 at 09:32 PM
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?
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Dec 6, 2009 at 09:09 PM
```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