You can use the following basic syntax to generate a random date between two dates in Google Sheets:
This particular formula will generate a random date between 1/1/2015 and 12/13/2022.
The following example shows how to use this formula in practice.
Example: Generate Random Dates in Google Sheets
We can type the following formula in cell A2 to generate a random date between 1/1/2015 and 12/31/2022:
The following screenshot shows how to use this formula in practice:
We can see that the formula produced the date 4/30/2018.
If we click and drag this formula down to other cells in column A, the formula will automatically produce a list of random dates between 1/1/2015 and 12/31/2022:
The result is a list of 20 date that all fall between 1/1/2015 and 12/31/2022.
Note #1: Whenever you update the value of any other cell in the worksheet and press Enter, the value of the random dates will change.
Note #2: If you don’t use the TO_DATE() function in the beginning of the formula, the random date that is generated will be formatted as a numeric value instead of a date.
The following tutorials explain how to perform other common tasks in Google Sheets: