B bonair Apr 13, 2009 #1 I have dates (1, 15, 21) in various cells. I want to count JUST the dates, no spaces or comas.
J Jacob Skaria Apr 13, 2009 #2 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
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
D Dave Peterson Apr 13, 2009 #3 =LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+(A1<>"") Will count the number of entries separated by commas.
