Random date generator
Excel can generate lots of random things! From dates, numbers to names, it’s up to you to tell Excel what you want!
If you want to know how to generate random numbers click here: “Did you know Excel can generate random numbers?"
Excel Formula:
=RANDBETWEEN(DATE(year,month,day),DATE(year,month,day))
The above formula contains two formulas:
RANDBETWEEN: =RANDBETWEEN(bottom, top)
DATE: =DATE(year, month, day)
Example
When creating my raw data for ‘Mad Hatter Chocolatier’, I wanted a list of dates but in a random order for the month of April.
Notes: Data and images are from the following:
Mad Hatter Chocolatier data is my own
Calendar image from clipartix.com
Comments