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.