Format A2 as date and copy A2 down
(can copy down a max of 150* rows)

Format C1 as date and copy C1 across
(can copy across a max of 150* cols)

Just a clarification that the random weekdays generated within the (max) 150
cells filled down/across will be non-repeating random weekdays from within
the 150 weekdays in the source range (col C in Sheet1)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----