This quick tutorial will demonstrate how to create a set of random dates in Excel using the RANDBETWEEN function. By default, randbetween will only give you numbers (integers) not dates. I will show you how to modify the standard function to get the desired result.
You may ask why I would use randbetween. As an instructor, it is helpful to quickly generate fake data sets for demonstrations. I have also seen it used a lot to generate numbers for games or to pick a winner of a contest. I leave it to your imagination about how you would use this function.
✨ Did you enjoy this video or find it useful? Support the channel:
↠ Koji Tip Jar: https://withkoji.com/@HeatherMajors
//Here are some of the tools that I use to create the videos on my channel. (Heather Majors)
▶ Video Editing Software: Camtasia https://techsmith.z6rjha.net/BXzWWq
▶ Screen Capture and Video Capture Software: SnagIt https://techsmith.z6rjha.net/BXzWWq
▶ vidIQ: https://vidiq.com/HeatherMajors
Some product links are affiliate links which means if you buy something I will receive a small commission at no additional cost to you.