Randomly generate dates of the current month and excludes weekends

I am trying to create a form that randomly generate dates of the current month and excludes weekends.

I tried to us “=RANDBETWEEN(DATE(2016, 08, 01),(DATE(2016, 08, 31))” this resolves the date range but I have to change the formula each month and it does not exclude weekends.

I created a list of dates using the autofill option, selecting weekdays to remove weekend from my list but I can’t use the field location to substitute in the date field (DATE(2016, 08, 01).

This method does not work because it involves modify this every month.

I tried using “=WORKDAY(C2, 20, F2:F14)” which will exclude weekends and holidays I choose but I can’t seem to make random. I know I am close but…


I have tried to include an attachment but When I select the attachment icon all I get is a small box.Capture.JPG