Count Dates in a cell

Bob Kernan

Is it possible to count the number of dates (mm/dd) that show up in a cell? Would the format of the dates need to include a year as well? In the example below I have two dates in the cell.

If this is not possible, how would I count the number of dates in a date column

Andrée Starå

Hi @Bob Kernan

I hope you're well and safe!

Here's an excellent solution from RossL that could work.

I came up with a solution, it is not the most elegant but it works. below is a link to the sheet I made. what it is doing is looking for the key word and using helper rows to find the start of that word and then the next column in the line will find the next one by start its search after the first word, then the start of the next occurrence ect. the green column counts all the columns that have a position noted.

https://app.smartsheet.com/b/publish?EQBCT=78c55d4176554b85afc0ef5bf456f4b1

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!