Forum Discussion
Need some help with a formula
I need a column to allow me to Add multiple dates in 1 cell, then total the amount of dates in another cell. See the attached file for reference on what I need. Example Dates: in cell B: 1, 5, 12, ...
Format C8 as General instead of as Text, and enter the following formula in C8:
=LEN(B8)-LEN(SUBSTITUTE(B8,",",""))+1
Does it always have to have the 1? sometimes the final will be zero, if they didn't use that particular service. Or can I just put 0 as needed?
HansVogelaar this is what happened 😞 Sometimes the cell will be zero also.
stephbuch11 When you copied down you somehow kept the first cell reference as C8. Did you copy down or paste the text in each cell and manually update? I corrected the problem in the attached and added the empty condition to =0.
mtarler ahhhh perfect, and I also see the 0, I tried to do that myself, but put it in the wrong place. Thanks so much!
