However, Excel's random number functions are ... Then, once you've entered your random number function, click "Calculate Now" to update the random values.

then click OK, and copy down. The results are Excel serial numbers, so you must choose Format>Format Cells>Number>Date, and then select a format from the list. Use this function to display the ...