Counting Nr of Entries in a Column which are Formatted as Date or Text or Number
It may have no worksheet function to do this, but VBA have a function
"isdate".
Define a function:
Function CountDate(ra As Range)
Dim rCel As Range, i%
For Each rCel In ra
If IsDate(rCel) Then i = i + 1
Next
CountDate = i
End Function
ra is the range you want to count date.
дÈëÏûÏ¢
...
Dear Excel Community,
I have a column of 600 data entries. It is in cells B11 to B610. In the
first few rows above the column I'd like to summarise the number of cells
which are (a) date format - not too fussy which particular date format,
just want to know that it is a date (b) number format (c) text format. I
can get blank using =countblank(B11:B610) - with there was a CountDate()
and CountNumber() formula - any help appreciated.
(I actually have tonse of columns - but answers to the above will assist.
I've been working-around matters with AutoFilters - but a formula approach
would be so helpful.
Thanks in advance, Gerry.
|