Insert Random Dates in Excel

To insert a Random Date between 05-Jan-2014 and 30-Jun-2014, use the below formula. You can customize the formula as per your requirement.


Note: After you insert the formula you need to set the number format to Date, otherwise you’ll just see numbers.

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply