MS Excel count Range in single cell

[rusa31]

Hello,

Im doing employee "Date On-Leave" data in excel. There are more than 10 employee that I have to key-in for every month.
so im planning to create a formula to make my work more effective and also to avoid human mistake.
I need help on the for formula that can give Total count of multiple range number in single cell.

Attached picture:-

Info :-

1) Calculate Range in single cell
2) Every range number separated by comma ","
3) could be more than one comma ","

Note : Sorry. I cannot change the table design. My bos wanted this way.

Really appreciate for the help.

Thank you.

 

[JoeMo]

Thank you Joe.
Your are awesome.

You are welcome - thanks for the reply.