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
Sweet! That totally worked thank you!