Definition :- Actually We Can’t Generate Random Date With Only Date Function. To Generate The Random Dates We Will Need One More Valuable Function Called Rand Between To Put In Action Together With Date Function And With The Help Of Both The Function We Can Generate A Random Dates By Giving A Specific Dates Range From Bottom To Top Same As We Generate Random Numbers. For More Details Please Check Image And Video Provided Below.
Validation :-
- Make Sure That You Must Have First Bottom (Smaller) Date And In Second Parameter Top (Higher) Date Selected Or Added. Other Wise It Will Give You #Num Error.
- Make Sure You Have Added Date In Proper Format According To Your PC Settings.
- Make Sure That You Have Proper Format Date When You Give A Direct Cell Reference As Shown In Image.
