Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in


How to generate random date quickly in Excel?

When you use an Excel file, sometimes you want to generate random date for some purpose, of course, you can enter the date manually one by one, but if you need to insert multiple date, this method will be time-consuming and boring. How to quickly generate random date on earth in Excel?

Generate random date in cells with Function

Generate random date in cells with Kutools for Excel

arrow blue right bubble Generate random date in cells with Function

In Excel, you can mix the Randbetween and Date function to create random date, please do as follows:

1. Select a cell that you want to insert a random date, and enter this function: =RANDBETWEEN(DATE(2013, 1, 1),DATE(2013, 3, 1)).

Note: in the function, (2013, 1, 1) is the starting date, and (2013, 3, 1) is the ending date, you can replace them as you need.

2. Then press Enter key, it displays a five-digit number in the cell, and you need to convert this format to the date format.

3. Select the cell, and right-click, choose Format Cells from the context menu, see screenshot:


4. And in the Format Cells dialog box, click Number tab, and select Date from the Category, then select a date format you need from the Type drop-down list. See screenshot:


5. Click OK, the number has been converted to the normal date format. Then click the cell and drag the fill handle over to the range that you want to fill with random date. And the date has been generated randomly. See screenshot:


arrow blue right bubble Generate random date in cells with Kutools for Excel

It seems that the above method is some troublesome, is there an easier and quicker way to solve this problem? Don’t worry, with Kutools for Excel’s Insert Random Data tool, you can quickly insert the following random date:

  • Generate only the workday date;
  • Generate only the weekend date;
  • Generate any date (including workday date and weekend date);
  • Generate random unique date

Kutools for Excel includes more than 300 handy Excel tools. Free to try with no limitation in 30 days. Get it Now.

When you have installed Kutools for Excel, please do as the following steps:

1. Select the cells range that you want to insert the random date.

2. Click Kutools > Insert Tools > Insert Random Data, see screenshot:


3. In the popping up Insert Random Data dialog box, click Date tab, then specify the date scope, and choose the date type (workday date, weekend date or unique date) as you need. See screenshot:


4. Then click OK or Apply button, and the date has been generated into the cells as following screenshot shows:


Note: This method is simple and quick, but there is only one date type can be generated.

Click to know more about this Insert Random Data feature.

Related articles:

Generate random number without duplicates in Excel

Generate random strings

Insert random numbers in a range

Recommended Productivity Tools

Ribbon of Excel (with Kutools for Excel installed)

300+ Advanced Features Increase Your Productivity by 71%, and Help You To Stand Out From Crowd!

Would you like to complete your daily work quickly and perfectly? Kutools For Excel brings 300+ cool and powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) for 1500+ work scenarios, helps you solve 82% Excel problems.

  •  Deal with all complicated tasks in seconds, help to enhance your work ability, get success from the fierce competition, and never worry about being fired.
  •  Save a lot of work time, leave much time for you to love and care the family and enjoy a comfortable life now.
  •  Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands, and give you a healthy body.
  •  Become an Excel expert in 3 minutes, and get admiring glance from your colleagues or friends.
  •  No longer need to remember any painful formulas and VBA codes, have a relaxing and pleasant mind, give you a thrill you've never had before.
  •  Spend only $39, but worth than $4000 training of others. Being used by 110,000 elites and 300+ well-known companies.
  •  60-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years. Buy once, use forever.
  •  Change the way you work now, and give you a better life immediately!

Office Tab Brings Efficient And Handy Tabs to Office (include Excel), Just Like Chrome, Firefox, And New IE

  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Open and create documents in new tabs of same window, rather than in new windows.
  • Help you work faster and easily stand out from the crowd! One second to switch between dozens of open documents!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    lapolisia · 2 months ago
    lapolisia te baneara esta pagina panchito huevonazo
  • To post as a guest, your comment is unpublished.
    TU FRUTA MADRE · 2 months ago
  • To post as a guest, your comment is unpublished.
    Juan cortez · 2 years ago
    Random dates
    June 22 2018
    July 3 2018
    October 21 2022
    June 1 2026
    July 3 2045
  • To post as a guest, your comment is unpublished.
    Juan Cortez · 2 years ago
    NFL 2017 season 2 week
    Seattle Seahawks New England Patriots
    San Diego Chargers Washington redskins
    Los Angeles Rams Tampa bay Buccaneers
    Philadelphia Eagles Pittsburgh Steelers