How To Count Comma Separated Values In A Single Cell

[Ebba]

Hi there
I have created a table for a client who needs to record the dates visits are made to a site. We note the dates in one cell, separated by commas. We would like to use this data to view the total number of visits. Is there are way to count comma separated values in Airtable?
Thank you!

[gwynn_kruger]

One way may be to make the dates a multi-select field type:

The formula for Visit Count is then:
IF({Visit Dates},LEN({Visit Dates})-LEN(SUBSTITUTE({Visit Dates},",",""))+1)

[Ebba · Accepted solution]

Thank you so much for this, Gwynn. It worked perfectly! I really appreciate your support :slightly_smiling_face: