Ok, this seems simple enough for someone who may know the correct function/formula.

Basically this.

Saturdays are always 2%
The rest of the work days are equal, but the total for all can only be 100%

In the spreadsheet it looks like this

THUR %
FRI %
SAT 2%
MON %
TUES %
WED %

and so on. for the current month. There could be more saturday's in a month than 4. I'm needing something that looks for the text SAT and multiplies the number of it finds by 2, that will give a number. Subtract that from 100, then spread the % out evenly to each weekday.