Excel - Random Sampling

I have a list of names and a separate table of with Monday to Friday with percentages next to each total which in total equal to 100%.

So Monday is 30%, how I do make sure 30% of that list is Monday, 20% for Tuesday etc.

I've tried using the formulas in the link below but it just returns Monday for each row https://www.extendoffice.com/documents/excel/4486-excel-random-with-probability.html