Randon date generation prior to 1900s

[Biking Loki]

I am trying to figure out a way to generate a random date that will also consider dates prior to 1900. I've fiddle around with the RANDBETWEEN function but that seemed to only generate dates at the upper end of the range. Also, I could not get it to work for pre-1900 dates.

Does anyone have any suggestions for a formula or method to make this possible? Is it even possible given Excel's issues with dates prior to the 1900s?

Thank you in advance.

 

[Biking Loki]

That does work. Thanks for all your patience and help.