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.
=RANDBETWEEN(DATE(2014,1,5),DATE(2014,6,30))
Note: After you insert the formula you need to set the number format to Date, otherwise you’ll just see numbers.
Leave a Reply
Want to join the discussion?Feel free to contribute!