Counting number of dates in a column

R

Rick

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

thanks,

Rick
 
T

TKT-Tang

Mr. Frank Kabel,

Is there further differentiation between a number and a date ?

Regards
 
P

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
 
D

Dave Peterson

You have one more response to your other post.

TKT-Tang said:
Mr. Frank Kabel,

Is there further differentiation between a number and a date ?

Regards
Click to expand...
 
T

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.
 
Top