Counting in Excel

A

Angel160

We use a spreadsheet to log deals executed. I need to count the numbe
of deals executed in a particular month.

The deals are logged by trade date written as dd/mm/yy.

I have tried Countif but this does not work for a range of data (fo
example 01/09/04 to 30/09/04).

Can anyone help?

Thank
 
S

SPIRONIK

Try some things.
First of all, see if thr format of cells (menu format cells) are dat
with the form dd/mm/year.
If this does not work, a pivot would solve your problem
 
M

Myrna Larson

=COUNTIF(A1:A100,">="&DATE(2004,9,1))-COUNTIF(A1:A100,">"&DATE(2004,9,30))
 
Top