Formula to check if all cells in a column are dates (and numbers)

[tonywatsonhelp]

Hi Everyone,

Ok this is what i need. a formula to tell me if all cells in a range are a date so lets asy the range is D11:D1100

also if you show me how to change it to check for numbers decimal is fine, this would be perfect
thanks
Tony

 

[gaz_chops]

Dates are numbers!

 

[gaz_chops]

To check for numbers, try

=COUNT(D11:D1100)=ROWS(D11:D1100)

 

[tonywatsonhelp]

thanks gaz

 

[jasonb75]

@gaz_chops' suggestion is fine if all rows are to be assumed filled, if you need to ignore empty cells then try

=COUNT(D11:D1100)=COUNTA(D11:D1100)

Although this will not work if there are formula blanks in the range.

 

[gaz_chops]

@gaz_chops' suggestion is fine if all rows are to be assumed filled, if you need to ignore empty cells then try

=COUNT(D11:D1100)=COUNTA(D11:D1100)

Although this will not work if there are formula blanks in the range.

I took it that a blank cell would be counted as not a date.

 

[jasonb75]

Possibly, Gaz. As with many questions, there is a lot open to interpretation. What I meant was that if the range was larger than needed to allow for future entries then comparing count to number of rows would not match up.

If that was the case then eliminating those empty cells might require one of several different methods, or I could just be thinking too far out of the box