View Single Post
  #2   Report Post  
Old December 29th 04, 04:43 AM
Max
 
Posts: n/a
Default

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?