I would like to create a COUNTIF formula and use a date range (9/1/04 through
9/30/04) as the criteria. How do I phrase the formula?

One way:

Assuming the dates to be counted are in col A,
and you have the criteria start / end dates
in B1: 9/1/04, in C1: 9/30/04

you could put in D1:
=COUNTIF(A:A,"="&B1)-COUNTIF(A:A,""&C1)

Format D1 as General or Number

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

"mbparks" wrote:

I would like to create a COUNTIF formula and use a date range (9/1/04 through
9/30/04) as the criteria. How do I phrase the formula?

Fabulous. Thanks for all the help.
Happy New Year!

"Max" wrote:

One way:

Assuming the dates to be counted are in col A,
and you have the criteria start / end dates
in B1: 9/1/04, in C1: 9/30/04

you could put in D1:
=COUNTIF(A:A,"="&B1)-COUNTIF(A:A,""&C1)

Format D1 as General or Number

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

"mbparks" wrote:

I would like to create a COUNTIF formula and use a date range (9/1/04 through
9/30/04) as the criteria. How do I phrase the formula?

You're welcome !
Thanks for feedback
Happy new year !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"mbparks" wrote in message
...
Fabulous. Thanks for all the help.
Happy New Year!