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))