=COUNT(G2:G113)

will count all numeric values and since you only have dates or blanks and
excel dates are numbers it should tell you how many dates

=COUNTBLANK(G2:G113)

count blank cells and

ROWS(G2:G113)

count rows thus cells


Regards,

Peo Sjoblom

"CiCi Bird" wrote:

> Hi Dave R.
> I am counting the number of cells that contain a date (01/01/05 for
> example), but each cell contains a different date. All other cells are blank
> with no conditional formatting other than each cell is formatted for a
> "date". Does this provide the info you need? Thanks so much! CiCi
>
> "Dave R." wrote:
>
> > You don't say what you want to count but I guess dates. Dates are values,
> > and count counts values, so maybe your dates are not values? Or your "blank"
> > cells contain some numbers and are hidden by conditional formatting?
> >
> >
> >
> > "CiCi Bird" <CiCi Bird@discussions.microsoft.com> wrote in message
> > news:89D196AD-DEE2-46BB-B0AC-81BB736B55C3@microsoft.com...
> > > I have one column of over 100 cells that are either blank or contain a
> > date.
> > > If I use the following, it doesn't add them up correctly.
> > > =COUNTIF(G2:G113,"*") or
> > > =COUNT(G2:G113)
> >
> >
> >