Generate Random Number for "Work from Home"

Formulas with a macro works pretty well - open the file, enable macros, and click the button.

Note that with 7 staff members and 15 slots to fill, Steve will always have 3 days in the office (since he is the only one selected to be in more than twice)

Here is a solution with a recursive formula.

The recursive formula generates an absolutely random schedule that meets all your requirements.
The person who is assigned 3 times is also random.

Please add to the namemanager: genplan:

=LAMBDA(LET(
t,DROP(REDUCE("",DEC2BIN(SEQUENCE(2^7,,0),7),LAMBDA(i,c,VSTACK(i,--MID(c,SEQUENCE(,7),1)))),1),
x,CHOOSEROWS(FILTER(t,3=BYROW(t,LAMBDA(r,SUM(r)))),TAKE(SORTBY(SEQUENCE(,COMBIN(7,3)) ,RANDARRAY(,COMBIN(7,3))),,5)),
IF(MIN(BYCOL(x,LAMBDA(c,SUM(c))))=2,IF(x,"x","" ),genplan())))

and delete all expected results and try

Formula:

=genplan()

Wow! - I got an error message about this part:

--MID(c,SEQUENCE(,7)) ,1)

I think it needs one fewer right parens:

--MID(c,SEQUENCE(,7) ,1)

then it worked wonderfully....

@Bernie, Thanks for the feedback and pointing the error. It is a typo. I'll remove the bracket in Post #4.

In the attached file the formula is correct.

You are Welcome!

Thanks for the feedback and glad to have helped. .

If you haven't already, please consider adding reputation to all helpers you think they deserve.
In that case please click * Add Reputation left below their answers.