Learn Excel - "Random Weeks Over 6 Months": #1469A 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.