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.
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.