How do I count just the numbers in a cell, no spaces or comas?
 

I have dates (1, 15, 21) in various cells. I want to count JUST the dates,
no spaces or comas.

How do I count just the numbers in a cell, no spaces or comas?
 

Suppose A1 = 1, 15, 21
The below formula will give you the number of dates..

=LEN(D13)-LEN(SUBSTITUTE(D13,",",""))+1

If this post helps click Yes
---------------
Jacob Skaria


"bonair" wrote:

I have dates (1, 15, 21) in various cells. I want to count JUST the dates,
no spaces or comas.

How do I count just the numbers in a cell, no spaces or comas?
 

=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+(A1<"")

Will count the number of entries separated by commas.

bonair wrote:

I have dates (1, 15, 21) in various cells. I want to count JUST the dates,
no spaces or comas.

--

Dave Peterson