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