Counting number of dates in a column

[Rick]

Hi - Is there a way to count the number of dates in a
column that contains both text and dates ?

thanks,

Rick

 

[Frank Kabel]

Hi Rick
try
=SUMPRODUCT(--(ISNUMBER(A1:A1000)))

 

[Rick]

Thanks Frank !

Quick question - what do the two dashes do in the formula?

thx

Rick

 

[Frank Kabel]

Hi
quick answer
coerces the boolean values to numbers (TRUE=1/FALSE=0)

 

[TKT-Tang]

Mr. Frank Kabel,

Is there further differentiation between a number and a date ?

Regards

 

[Peo Sjoblom]

A date is a number, excel counts from January 0 1900, thus if
you use today's date 05/17/04 and format is as General it will
display as 38126 days after Jan 0 1900. So there is no difference except the
format

 

[Dave Peterson]

You have one more response to your other post.

Mr. Frank Kabel,

Is there further differentiation between a number and a date ?

Regards

 

[TKT-Tang]

Mr. Peo Sjoblom,

Thank you for responding to my query.

Now that a date and a number have virtually coalesced into an identity
(of the latter) to ease mathematical operations. That's a good thing
on one side of the coin.

It's the daily experience dictating that when an (apparent) date is
entered, a worksheet formula ought to be capable of distinguishing it
from a number. While addition and substraction could be performed on
dates, multiplication and division on that entity are far removed from
the daily experience (hence that's not intuitive and to be prevented).

Is there any improvement upon the prevalent situation, please ?

Regards.