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

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:

Format D1 as General or Number

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?