Wildcard to count days and weekends

I am trying to count the number of days and weekends that are in a cell but I can't see to figure it out. Attached is an excel file showing the results that I manually typed in. Is there a way to create formulas to do this? I tried an if function but because the cell contains more than one day it will not give me the results I need. I tried the wildcard function but it would not work with the If formula. I can't figure out the Find and Search formulas so I am hoping someone can help.

Thanks in advance.

I can't figure out what you are trying to calculate.

Shouldn't Sun, Mon be = 1 day and 1 weekend?

Try this in C5:

=LEN(B5)-LEN(SUBSTITUTE(B5,",",""))+(LEN(B5)>0)

in D5:

=SUM(COUNTIF(B5,{"*Sat*","*Sun*"}))

Oh I get it now.

The days input in the column were input by other users so I am trying to convert them to the results I need. For example, if Sat, Mon and Thurs, are in the cell, I want to show 3 days and 1 weekend day. If the cell shows Sat, Sun, Mon, Tues, I want the result to show 4 days and 2 weekends. I hope that helps.

Or these:

=SUM(COUNTIF(B5,TEXT({0,1,2,3,4,5,6},"\*ddd\*"))) to count days

=SUM(COUNTIF(B5,TEXT({0,1},"\*ddd\*"))) to count weekends

Brilliant! Thank you!