=RANDBETWEEN(DATE(bottomdate),DATE(topdate)
http://www.techrepublic.com/blog/microsoft-office/generate-random-dates-within-a-specific-date-range/
=INDEX($A:$A,RANDBETWEEN(1,COUNTA($A:$A)),1)
http://www.ozgrid.com/Excel/excel-random-pick.htm
fake name generator
http://dailydoseofexcel.com/archives/2006/07/13/random-name-generator/
