Random Dates
In Excel dates are stored as numbers.
To generate random dates you can use the RANDBETWEEN function with a start date and an end date.
The formula in cell C2 is
=RANDBETWEEN(A2,B2)
Cell C2 has been formatted as a date.
This formula is dynamic. Each time Excel calculates it will update and most likely change.
You can use Copy > Paste Values to capture the date(s).
Please note: I reserve the right to delete comments that are offensive or off-topic.