mafallaize
New Member
- Joined
- Aug 23, 2011
- Messages
- 31
Hi all,
This problem has had me stumped for a while now. I'm looking for a formula to produce unique random dates between a date range, excluding weekends and a list of public holidays (different for each year). Like a lottery, once a date has been selected, it shouldn't be used again.
My sheet looks like this:
<tbody>
</tbody>
NETWORKDAYS works well for all of the above requirements, except it creates duplicates.
The Lottery style UDF posted by Jon von der Heyden here could be useful, but I couldn't get it to exclude weekends: https://www.mrexcel.com/forum/excel-questions/638342-formulae-help-please.html
Any ideas would be appreciated!
Thanks
Mark
This problem has had me stumped for a while now. I'm looking for a formula to produce unique random dates between a date range, excluding weekends and a list of public holidays (different for each year). Like a lottery, once a date has been selected, it shouldn't be used again.
My sheet looks like this:
Sampling start date | Sampling end date | 1 | 2 | 3 | 4 | 5 |
01/10/2017 | 01/01/2018 | |||||
01/01/2018 | 01/04/2018 | |||||
01/04/2018 | 01/07/2018 | |||||
01/07/2018 | 01/10/2018 |
<tbody>
</tbody>
NETWORKDAYS works well for all of the above requirements, except it creates duplicates.
The Lottery style UDF posted by Jon von der Heyden here could be useful, but I couldn't get it to exclude weekends: https://www.mrexcel.com/forum/excel-questions/638342-formulae-help-please.html
Any ideas would be appreciated!
Thanks
Mark