A YouTube viewer wants to find a way to generate random weeks over the next 6 months. In Episode #1469, Bill – using TODAY, WEEKDAY, and RANDBETWEEN Functions – shows us a Formula to calculate random weeks for the next 6 months or year.