Dates & Text?

[Ken]

Excel2003 ... My Range contains "Date" values & various "Text" values ... I
wish a formula to count the "Text" values only.

01/01/09
01/02/09
H
01/04/09
V
01/06/09
01/07/09
01/08/09
O/S
01/10/09

Formula should return ... 3

Thanks ... Kha

 

[Gary''s Student]

=COUNTA(A1:A100)-COUNT(A1:A100)

 

[Mike H]

One way

=COUNTA(A1:A10)-COUNT(A1:A10)

Mike

 

[John]

HI Ken
Try this one also works: =SUMPRODUCT(ISTEXT(A10:A19)+0)
HTH
John

 

[Dave Curtis]

Hi,

Even shorter formula is just =COUNTIF(A1:A100,"*")

Dave

 

[Ken]

A slight wrinkle here ... I just realized that some of the cells I thought
were BLANK or EMPTY actually contain a single apostrophe ( ' ) ... which this
formula picks up as "Text" ... I need to exclude these ... I could do another
minus (-) countif, but my problem will also compound in that I have 4 non
contiguous ranges. Just kill 1 snake @ a time I guess???

Thanks ... Kha

 

[Ken]

Board ... Previously, I may have been writing this incorrectly ...

What I want for a returned value is:

The NETWORKDAYS ... between TODAY & 01/01/09 ... excluding any DAYs with
TEXT Codes (that are not WEEKENDS).

Thanks ... Kha