I want to count dates in a single cell. The dates will be written in the form of: 05 09 11 21. I could use commas to separate the dates or even both commas and spaces. Searching on the internet, I have found two ways I can to do this – it’s just sad that none of them work.
Here’s what I have found:

1. =LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1),",","")+1 (using commas to separate the text) (The brackets around TRIM(A1) are red and, so is the last bracket)

2. =LEN(A1)-LEN(SUBSTITUTE(A1," ",""))+1 (using a space to separate) (The brackets around (A1," ","") are red)

I have written the formulas as they appear in the fx field, so it appears that the brackets are wrong. I think my version of Excel is the latest
Ideally I would like to allow for an either commas or spaces for input, but as I haven’t managed to get past elementary school Excel level, I’ll hold.