Generate Random Dates in Excel
How to generate random dates in Excel.
This tip shows you how to set a date range and then generate any date between those two ranges.
This combines the use of one of the random functions along with the DATE() function.
=DATE(RANDBETWEEN(2000,2022),RANDBETWEEN(1,12),RANDBETWEEN(1,31))
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Macro: Generate a series of non-repeating random numbers in Excel with this UDF (user defined fun...
Tutorial: I'll explain how dates in Excel work and then point you to many useful tutorials on how t...
Tutorial: I have found a rather convoluted method to Calculate the Number of Years, Months and Days ...
Tutorial: Introduction Guide to using Dates in Excel - this tutorial will show you how to input and...
Tutorial: How to calculate the total number of working days between two dates in Excel. This allow...
Tutorial: Watch this tutorial if you work with dates! Quick and easy ways to reliably convert dates...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)