Table of Contents
To generate random dates in Google Sheets, you can use the built-in “RAND” or “RANDBETWEEN” function. These functions will generate a random number between specific dates, which can then be formatted as a date using the “FORMAT” function. Additionally, you can use the “DATE” function to specify a specific date range to generate random dates within. It is important to note that these functions will recalculate each time the sheet is opened or edited, so it is recommended to copy and paste the values into a separate column to avoid changes. By using these functions, you can easily generate a list of random dates in your Google Sheets document.
Generate Random Dates in Google Sheets
You can use the following basic syntax to generate a random date between two dates in Google Sheets:
=TO_DATE(RANDBETWEEN(DATE(2015,1,1),DATE(2022,12,31)))
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:
=TO_DATE(RANDBETWEEN(DATE(2015,1,1),DATE(2022,12,31)))
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:
Cite this article
stats writer (2024). How can I generate random dates in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-generate-random-dates-in-google-sheets/
stats writer. "How can I generate random dates in Google Sheets?." PSYCHOLOGICAL SCALES, 26 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-generate-random-dates-in-google-sheets/.
stats writer. "How can I generate random dates in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-generate-random-dates-in-google-sheets/.
stats writer (2024) 'How can I generate random dates in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-generate-random-dates-in-google-sheets/.
[1] stats writer, "How can I generate random dates in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I generate random dates in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.