Should you need to get random dates in Excel, here’s how to do it:
- Format the cells you are going to put the random dates in as “date”.
- To pick a random date, use the formulas RANDBETWEEN() or RAND() with specific parameters. The best way to generate dates is by subtracting random values from TODAY()
Random date in last 30 days:
=TODAY() – RANDBETWEEN(0;30)
or
=TODAY() – RAND()*30
Random date in the next 30 days:
=TODAY() + RANDBETWEEN(0;30)
or
=TODAY() + RAND()*30
Random date in the last 365 days:
=TODAY() – RANDBETWEEN(0;365)
or
=TODAY() – RAND()*365
Replace the 365 with whatever number of days you will need your random date to begin from.